Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Remarks

ExcelWriter supports Excel's 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
titleC#

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open(@"C:\Reports\Report.xls", "MyPassword");
        
Code Block
vb.net
vb.net
titlevb.net

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Open("C:\Reports\Report.xls", "MyPassword")