SpreadsheetFormat

SpreadsheetFormat enumeration

Defines various spreadsheet subformats.

public enum SpreadsheetFormat

Values

Name Value Description
Unknown 0 The format is not recognized.
Xls 1 Represents the .XLS Excel format. Files with XLS extension represent Excel Binary File Format. Such files can be created by Microsoft Excel as well as other similar spreadsheet programs such as OpenOffice Calc or Apple Numbers. File saved by Excel is known as Workbook where each workbook can have one or more worksheets. Learn more about this file format here.
Xlsb 2 Represents the .XLSB Excel format. XLSB file format specifies the Excel Binary File Format, which is a collection of records and structures that specify Excel workbook content. The content can include unstructured or semi-structured tables of numbers, text, or both numbers and text, formulas, external data connections, charts and images. Learn more about this file format here.
Xlsx 3 Represents the .XLSX Excel format. XLSX is well-known format for Microsoft Excel documents that was introduced by Microsoft with the release of Microsoft Office 2007. Based on structure organized according to the Open Packaging Conventions as outlined in Part 2 of the OOXML standard ECMA-376, the new format is a zip package that contains a number of XML files. Learn more about this file format here.
Xlsm 4 Represents the .XLSM Excel format. Files with XLSM extension is a type of Spreasheet files that support Macros. From application point of view, a Macro is set of instructions that are used for automating processes. A macro is used to record the steps that are performed repeatedly and facilitates performing the actions by running the macro again. Learn more about this file format here.
Xltx 5 Represents the .XLTX Excel format. Files with XLTX extension represent Microsoft Excel Template files that are based on the Office OpenXML file format specifications. It is used to create a standard template file that can be utilized to generate XLSX files that exhibit the same settings as specified in the XLTX file. Learn more about this file format here.
Xltm 6 Represents the .XLTM Excel format. The XLTM file extension represents files that are generated by Microsoft Excel as Macro-enabled template files. XLTM files are similar to XLTX in structure other than that the later doesn’t support creating template files with macros. Such template files are used to generate and set the layout, formatting, and other settings along with the macros to facilitate creating similar XLSX files then. Learn more about this file format here.
Ods 7 Represents the Opendocument Spreadsheet format. Files with ODS extension stand for OpenDocument Spreadsheet Document format that are editable by user. Data is stored inside ODF file into rows and columns. It is XML-based format and is one of the several subtypes in the Open Document Formats (ODF) family. Learn more about this file format here.
Xlt 8 Represents the .XLT Excel format. Files with .XLT extension are template files created with Microsoft Excel which is a spreadsheet application which comes as part of Microsoft Office suite. Microsoft Office 97-2003 supported creating new XLT files as well as opening these. The latest version of Excel is still capable of opening this old format template files. Learn more about this file format here.

See Also