Wiki Markup |
---|
{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} |
Page History
Overview
Content Tools