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. | |
Page History
Overview
Content Tools