Page History

{description}
{excerpt}Opens an Excel workbook from a  stream and returns a [Workbook|Workbook] object.{excerpt}
{signature:C#}
 public virtual Workbook Open(System.IO.Stream stream)

{signature}{signature:vb.net

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

{signature}
{parameters}
{param:stream}A System.IO.Stream containing a OOXML format \(Excel 2007 or later\) .xlsx or BIFF8 format \(Excel 97 or later\) .xls file.

...

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.

{param}
{returns}A {{Workbook}} object representing the file opened.{returns}
{exceptions}
{exception:System.Exception}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.{exception}
{remarks}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.

{remarks}
{example}{code:csharp|title=C#}

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

{code}
{code:vb.net

|title=vb.net

}

          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)
        {code}

{example}