ExcelApplication.Open(System.IO.Stream, String)

Description

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

C#

vb.net

Parameters

stream

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

decryptPassword

The password used to encrypt the spreadsheet. Standard "Office 97/2000 Compatible" encryption is used to encrypt the spreadsheet. This is the default encryption used by Excel 97 and later versions.

Returns

A Workbook object representing the file to open.

Exceptions

System.Exception

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

Remarks

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

Examples

C#