Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

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

Signature
C#
C#
enum FileFormat
{signature}
{signature:
}
Signature
vb.net
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#}
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.

Example
Code Block
csharp
csharp
titleC#

Workbook wb = xla.Create(ExcelApplication.FileFormat.Xlsx);
{code} {code:vbnet|title=
Code Block
vbnet
vbnet
titlevb.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. |
Values

Name

Description

Anchor
Xls
Xls
Xls

Excel 2003 binary-format files, with the .xls extension.

Anchor
Xlsx
Xlsx
Xlsx

Excel 2007 and 2010 xml-format files, with the .xlsx extension.