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

Versions Compared

Old Version 1

changes.mady.by.user Unknown User (seank)

Saved on

compared with

New Version Current

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

Saved on

Key

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

...

Excerpt

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

...

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.Excel2003Xls can be opened in all versions of Excel. Excel files created with FileFormat.Excel2007Xlsx 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.Excel2007Xlsx);
Code Block
vb.netvb.netvbnet
vbnet
titlevb.net
Dim wb As Workbook = xla.Create(ExcelApplication.FileFormat.Excel2007Xlsx);
Values

Name

Description

Anchor
Excel2003XlsExcel2003
Xls
Excel2003 Xls

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

Anchor
Excel2007XlsxExcel2007
Xlsx
Excel2007 Xlsx

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