Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / OpenExcel Method / OpenExcel(Stream,String) Method
stream
Name of the sheet to load from the file
Example


In This Topic
    OpenExcel(Stream,String) Method
    In This Topic
    Opens an Excel stream and loads the specified sheet (by name) from that file into this sheet.
    Syntax
    'Declaration
     
    Public Overloads Function OpenExcel( _
       ByVal stream As Stream, _
       ByVal excelSheetName As String _
    ) As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim stream As Stream
    Dim excelSheetName As String
    Dim value As Boolean
     
    value = instance.OpenExcel(stream, excelSheetName)
    public bool OpenExcel( 
       Stream stream,
       string excelSheetName
    )

    Parameters

    stream
    stream
    excelSheetName
    Name of the sheet to load from the file

    Return Value

    TRUE if success. Otherwise, FALSE
    Example
    This example opens an Excel file.
    string fileName;
    fileName = "c:\\testexcel.xlsx";
    System.IO.Stream stream;
    stream = System.IO.File.Open(fileName, System.IO.FileMode.Open);
    fpSpread1.Sheets[0].OpenExcel(stream, "Sheet1");
    Dim fileName As String
    fileName = "c:\testexcel.xlsx"
    Dim stream As System.IO.Stream
    stream = System.IO.File.Open(fileName, System.IO.FileMode.Open)
    fpSpread1.Sheets(0).OpenExcel(stream, "Sheet1")
    See Also