Page History

...

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.

Note that ExcelWriter will not automatically re-encrypt a workbook that was opened with this method. If you want to ensure that your workbook is encrypted when saved, set the EncryptPassword property.

Example

Code Block

	csharp
	csharp
title	C#


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

Code Block

	vb.net
	vb.net
title	vb.net


          Dim xla As New ExcelApplication()
          Dim fStrm As FileStream = New FileStream("C:\Sales\2003\June.xlsxlsx")
          Dim wb As Workbook = xla.Open(fStrm, "MyPassword")

Space Shortcuts

Page tree

Versions Compared

Old Version 4

New Version Current

Key