OfficeWriter Documentation
.
ExcelWriter v9 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 1

changes.mady.by.user Gabe Goodwin [softartisans]

Saved on

compared with

New Version Current

changes.mady.by.user Scott Dugas [softartisans]

Saved on

Key

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

Description

Excerpt

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

Signature
C#
C#

enum FileFormat
Signature
vb.net
vb.net

Enum FileFormat
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 Block
vbnet
vbnet
titlevb.net

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

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.