Opens an Excel workbook from a stream and returns a Workbook object.

 public virtual Workbook Open(System.IO.Stream stream)
Public Overridable Function Open(ByVal stream As System.IO.Stream) As Workbook

A System.IO.Stream containing a OOXML format (Excel 2007 or later) .xlsx or BIFF8 format (Excel 97 or later) .xls file.

A Workbook object representing the file opened.

If the file cannot be found or opened, or if the file is not a OOXML format (Excel 2007 or later) .xlsx or BIFF8 format (Excel 97 or later) .xls file.

ExcelWriter supports Excel's OOXML (Excel 2007 or later) and BIFF8 (Excel 97 or later) format only. Do not use this method to open BIFF7 (Excel 95) files.


          ExcelApplication xla = new ExcelApplication();
          FileStream fStrm = new FileStream(@"C:\Sales\2003\June.xlsx", FileMode.Open);
          Workbook wb = xla.Open(fStrm);
        

          Dim xla As New ExcelApplication()
          Dim fStrm As FileStream = New FileStream("C:\Sales\2003\June.xlsx", FileMode.Open)
          Dim wb As Workbook = xla.Open(fStrm)