FlexGrid for WPF | ComponentOne
C1.WPF.Grid.Excel Assembly / C1.WPF.Grid Namespace / Extensions Class / LoadExcel Method / LoadExcel(FlexGrid,Stream,ExcelFileFormat,String,LoadExcelOptions) Method
Instance of the FlexGrid to load the data into.
A data System.IO.Stream.
A ExcelFileFormat file format.
The name of the Excel sheet to load. If null, the first sheet will be loaded by default.
A LoadExcelOptions loading options.

In This Topic
    LoadExcel(FlexGrid,Stream,ExcelFileFormat,String,LoadExcelOptions) Method
    In This Topic
    Loads Excel data from stream into the specified grid.
    Syntax
    'Declaration
     
    Public Overloads Shared Sub LoadExcel( _
       ByVal grid As FlexGrid, _
       ByVal stream As Stream, _
       ByVal fileFormat As ExcelFileFormat, _
       ByVal sheetName As String, _
       ByVal options As LoadExcelOptions _
    ) 
    public static void LoadExcel( 
       FlexGrid grid,
       Stream stream,
       ExcelFileFormat fileFormat,
       string sheetName,
       LoadExcelOptions options
    )

    Parameters

    grid
    Instance of the FlexGrid to load the data into.
    stream
    A data System.IO.Stream.
    fileFormat
    A ExcelFileFormat file format.
    sheetName
    The name of the Excel sheet to load. If null, the first sheet will be loaded by default.
    options
    A LoadExcelOptions loading options.
    Exceptions
    ExceptionDescription
    The exception that is thrown when one of the arguments provided to a method is not valid.
    See Also