SpreadsheetFileType class Leave feedback
On this page
Defines spreadsheet documents.
Includes the following file types:
SpreadsheetFileType.csvSpreadsheetFileType.fodsSpreadsheetFileType.odsSpreadsheetFileType.otsSpreadsheetFileType.tsvSpreadsheetFileType.xlamSpreadsheetFileType.xlsSpreadsheetFileType.xlsbSpreadsheetFileType.xlsmSpreadsheetFileType.xlsxSpreadsheetFileType.xltSpreadsheetFileType.xltmSpreadsheetFileType.xltx
Learn more about spreadsheet formats at https://wiki.fileformat.com/spreadsheet.
The SpreadsheetFileType type exposes the following members:
| Constructor | Description |
|---|---|
| init | Initializes a SpreadsheetFileType for serialization. |
| Method | Description |
|---|---|
| compare_to | Compares current object to other. (inherited from Enumeration) |
| compare_to_object | (inherited from Enumeration) |
| equals | Implements the equality comparison defined by Enumeration.equals. (inherited from FileType) |
| equals_enumeration | (inherited from FileType) |
| equals_object | (inherited from Enumeration) |
| from_display_name | (inherited from Enumeration) |
| from_extension | Gets the FileType for the provided file extension. (inherited from FileType) |
| from_filename | Returns FileType for specified file_name. (inherited from FileType) |
| from_stream | Returns FileType for provided document stream. (inherited from FileType) |
| from_value | (inherited from Enumeration) |
| get_all | (inherited from FileType) |
| get_hash_code | Provides the default hash function. (inherited from Enumeration) |
| to_string | String representation of file type. (inherited from FileType) |
| Property | Description |
|---|---|
| description | The file type description. (inherited from FileType) |
| extension | The file extension. (inherited from FileType) |
| family | The file family. (inherited from FileType) |
| file_format | The file format. (inherited from FileType) |
| Field | Description |
|---|---|
| XLS | XLS represents 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. Learn more about this file format here. |
| XLSX | XLSX is well-known format for Microsoft Excel documents that was introduced by Microsoft with the release of Microsoft Office 2007. Learn more about this file format here. |
| XLSM | XLSM is a type of Spreadsheet files that support macros. Learn more about this file format here. |
| XLSB | XLSB file format specifies the Excel Binary File Format, which is a collection of records and structures that specify Excel workbook content. Learn more about this file format here. |
| ODS | 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. Learn more about this file format here. |
| OTS | A file with .ots extension is an OpenDocument Spreadsheet Template file that is created with the Calc application software included in Apache OpenOffice. Calc application software is the similar to Excel available in Microsoft Office. Learn more about this file format here. |
| XLTX | XLTX file represents Microsoft Excel Template 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. |
| XLT | 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. Learn more about this file format here. |
| XLTM | 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. Learn more about this file format here. |
| TSV | A Tab-Separated Values (TSV) file format represents data separated with tabs in plain text format. Learn more about this file format here. |
| XLAM | XLAM is an Macro-Enabled Add-In file that is used to add new functions to spreadsheets. An Add-In is a supplemental program that runs additional code and provides additional functionality for spreadsheets. Learn more about this file format here. |
| CSV | Files with CSV (Comma Separated Values) extension represent plain text files that contain records of data with comma separated values. Learn more about this file format here. |
| FODS | A file with .fods extension is a type of OpenDocument Spreadsheet document format that stores data in rows and columns. The format is specified as part of ODF 1.2 specifications published and maintained by OASIS. Learn more about this file format here. |
| DIF | DIF stands for Data Interchange Format that is used to import/export spreadsheets data between different applications. These include Microsoft Excel, OpenOffice Calc, StarCalc and many others. Learn more about this file format here. |
| SXC | The file format SXC(Sun XML Calc) belongs to an office suite called OpenOffice.org. This format generally deals with the spreadsheet needs of users as it is an XML based spreadsheet file format. SXC format supports formulas, functions, macros and charts along with DataPilot. Learn more about this file format here. |
| NUMBERS | The files with .numbers extension are classified as spreadsheet file type, that’s why they are similar to the .xlsx files; but the Numbers files are created by using Apple iWork Numbers spreadsheet software. Learn more about this file format here. |
| FLAT_OPC | Flat OPC Excel is Office Open XML SpreadsheetML stored in a flat XML file instead of a ZIP package. |
| UNKNOWN | Unknown file type (inherited from FileType) |
Was this page helpful?
Any additional feedback you'd like to share with us?
Please tell us how we can improve this page.
Thank you for your feedback!
We value your opinion. Your feedback will help us improve our documentation.
