SpreadsheetFileType class

SpreadsheetFileType class

Defines Spreadsheet documents. Includes the following file types: SpreadsheetFileType.Csv, SpreadsheetFileType.Fods, SpreadsheetFileType.Ods, SpreadsheetFileType.Ots, SpreadsheetFileType.Tsv, SpreadsheetFileType.Xlam, SpreadsheetFileType.Xls, SpreadsheetFileType.Xlsb, SpreadsheetFileType.Xlsm, SpreadsheetFileType.Xlsx, SpreadsheetFileType.Xlt, SpreadsheetFileType.Xltm, SpreadsheetFileType.Xltx. Learn more about Spreadsheet formats here.

Inheritance: SpreadsheetFileTypeFileTypeEnumeration

The SpreadsheetFileType type exposes the following members:

Constructors

Constructor Description
init Serialization constructor

Properties

Property Description
file_format The file format
extension The file extension
family The file family
description File type description
UNKNOWN Unknown file type
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.

Methods

Method Description
equals Implements Enumeration.equals
compare_to Compares current object to other.
from_filename Returns FileType for specified fileName
from_extension Gets FileType for provided fileExtension
from_stream Returns FileType for provided document stream

See Also