SpreadsheetFormats

SpreadsheetFormats structure

Encapsulates all binary, XML and textual Spreadsheet formats (excluding all textual delimiter-based formats with separator like CSV, TSV, semicolon-delimited etc.), in which the workbook can be saved. Includes the following formats: Dif, Fods, Ods, Sxc, Xlam, Xls, Xlsb, Xlsm, Xlsx, Xlt, Xltm, Xltx. Learn more about Spreadsheet formats here.

public struct SpreadsheetFormats : IDocumentFormat, IEquatable<SpreadsheetFormats>

Properties

Name Description
Extension { get; } Returns an extension (without leading dot character) of this Spreadsheet format in lower case
Mime { get; } Returns a MIME code for this format
Name { get; } Returns a formal full name of this Spreadsheet format

Methods

Name Description
static FromExtension(string) Returns instance of SpreadsheetFormats structure, associated to specified filename extension, or throws an exception, if extension cannot be properly parsed
Equals(IDocumentFormat) Determines whether this instance is equal to the other specified IDocumentFormat instance
override Equals(object) Determines whether this instance is equal to the other specified object, that is presumably of boxed SpreadsheetFormats
Equals(SpreadsheetFormats) Determines whether this instance is equal to the other specified SpreadsheetFormats instance
override GetHashCode() Returns a hash-code, that is immutable for this instance
override ToString() Returns the name of this particular format, same as ‘Name’ property
operator == Checks two given SpreadsheetFormats instances on equality
operator != Checks two given SpreadsheetFormats instances on inequality

Fields

Name Description
static readonly Csv Comma Separated Values (CSV) documents represent plain text that contain records of data with comma separated values. Each line in a CSV file is a new record from the set of records contained in the file. Learn more about this file format here.
static readonly Dif Data Interchange Format (DIF)
static readonly Fods Flat OpenDocument Spreadsheet (FODS) — stored as a single uncompressed XML document
static readonly Ods OpenDocument Spreadsheet (ODS) 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.
static readonly SpreadsheetML SpreadsheetML — Microsoft Office Excel 2002 and Excel 2003 XML Format
static readonly Sxc StarOffice or OpenOffice.org Calc XML Spreadsheet (SXC)
static readonly Tsv Tab-Separated Values (TSV) file format represents data separated with tabs in plain text format. The file format, similar to CSV, is used for organization of data in a structured manner in order to import and export between different applications. Learn more about this file format here.
static readonly Xlam Excel Add-in (XLAM)
static readonly Xls Excel 97-2003 Binary File Format (XLS) represents files that 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.
static readonly Xlsb Excel Binary Workbook (XLSB)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.
static readonly Xlsm Office Open XML Workbook Macro-Enabled (XLSM) is a type of Spreasheet files that support macros. Learn more about this file format here.
static readonly Xlsx Office Open XML Workbook Macro-Free (XLSX) represents documents that was introduced by Microsoft with the release of Microsoft Office 2007. Learn more about this file format here.
static readonly Xlt Excel 97-2003 Template (XLT) represents 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.
static readonly Xltm Office Open XML Template Macro-Enabled (XLTM) 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.
static readonly Xltx Office Open XML Template Macro-Free (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.
static readonly All Returns an internal class, that provides enumerable possibilities over all existing Spreadsheet formats

Other Members

Name Description
class AllEnumerable Implements IEnumerable generic interface, that enables a ‘foreach’ possibility for the SpreadsheetFormats type

See Also