Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
{description}
{excerpt}
When creating Excel files with [{{Create}}|ExcelApplication.Create()], specifies which file format to use.
{excerpt}
{signature:C#}
enum FileFormat
{signature}
{signature:vb.net}
Enum FileFormat
{signature}
{remarks}
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.Xls}} can be opened in all versions of Excel.  Excel files created with {{FileFormat.Xlsx}} can be opened in Excel 2007 and later, or Excel 2003 with the [compatibility pack|http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=3].
{remarks}
{example}
{code:csharp|title=C#}
Workbook wb = xla.Create(ExcelApplication.FileFormat.Xlsx);
{code}
{code:vbnet|title=vb.net}
Dim wb As Workbook = xla.Create(ExcelApplication.FileFormat.Xlsx);
{code}
{example}
{values}
|| Name || Description ||
| {anchor:Xls}Xls | Excel 2003 binary-format files, with the .xls extension. |
| {anchor:Xlsx}Xlsx | Excel 2007 and 2010 xml-format files, with the .xlsx extension. |