When creating Excel files with Create, specifies which file format to use.

enum FileFormat
Enum FileFormat

Starting with Excel 2007, Microsoft introduced a new file format for office documents. This new format relaxes some of the restrictions of the old file formats; for example a single worksheet can now have over a million rows instead of sixty-five thousand.

Excel files created with FileFormat.Excel2003 can be opened in all versions of Excel. Excel files created with FileFormat.Excel2007 can be opened in Excel 2007 and later, or Excel 2003 with the compatibility pack.

Workbook wb = xla.Create(ExcelApplication.FileFormat.Excel2007);
Dim wb As Workbook = xla.Create(ExcelApplication.FileFormat.Excel2007);

Name

Description

Excel2003

Excel 2003 binary-format files.

Excel2007

Excel 2007 and 2010 xml-format files.