OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 10

changes.mady.by.user Unknown User (ozgurt)

Saved on

compared with

New Version Current

changes.mady.by.user Unknown User (ozgurt)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

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

Signature
C#
C#
 public virtual Workbook Open(System.IO.Stream stream)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Overridable Function Open(ByVal stream As System.IO.Stream) As Workbook
{signature}
{parameters}
{param:stream}A
Parameters
Param
stream
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#}

Returns

A Workbook object representing the file opened.

Exceptions
Exception
System.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.

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.

Example
Code Block
csharp
csharp
titleC#


          ExcelApplication xla = new ExcelApplication();
          FileStream fStrm = new FileStream(@"C:\Sales\2003\June.xlsx", FileMode.Open);
          Workbook wb = xla.Open(fStrm);
{code} {code:
 Code Block
vb.net
|title=
vb.net
titlevb.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}