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.{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}