SpreadsheetFormats
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