Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / OpenExcel Method / OpenExcel(Stream,ExcelOpenFlags,ExcelWarningList) Method
Stream
Open flag
List of Excel warnings
Example


In This Topic
    OpenExcel(Stream,ExcelOpenFlags,ExcelWarningList) Method
    In This Topic
    Opens an Excel Compound Document File and loads it into Spread with a list of warnings.
    Syntax
    'Declaration
     
    Public Overloads Function OpenExcel( _
       ByVal stream As Stream, _
       ByVal openFlags As ExcelOpenFlags, _
       ByVal warningList As ExcelWarningList _
    ) As Boolean
    'Usage
     
    Dim instance As FpSpread
    Dim stream As Stream
    Dim openFlags As ExcelOpenFlags
    Dim warningList As ExcelWarningList
    Dim value As Boolean
     
    value = instance.OpenExcel(stream, openFlags, warningList)
    public bool OpenExcel( 
       Stream stream,
       ExcelOpenFlags openFlags,
       ExcelWarningList warningList
    )

    Parameters

    stream
    Stream
    openFlags
    Open flag
    warningList
    List of Excel warnings
    Exceptions
    ExceptionDescription
    No stream specified or specified stream is null
    No stream specified or specified stream is empty
    Example
    This example opens an Excel file from a stream.
    string f;  
    f = "D:\\formula1.xls";  
    System.IO.FileStream s = new System.IO.FileStream(f, IO.FileMode.Open, IO.FileAccess.ReadWrite); 
    fpSpread1.OpenExcel(s, FarPoint.Excel.ExcelOpenFlags.DataOnly, new FarPoint.Excel.ExcelWarningList);
    
    
    Dim f As String 
    f = "D:\mptest.xls"
    Dim s As New System.IO.FileStream(f, IO.FileMode.Open,IO.FileAccess.ReadWrite)
    FpSpread1.OpenExcel(s, FarPoint.Excel.ExcelOpenFlags.DataOnly, New FarPoint.Excel.ExcelWarningList)
    
    See Also