SpreadsheetFormat
Inheritance: java.lang.Object, java.lang.Enum
All Implemented Interfaces: com.groupdocs.metadata.core.IEnumValue
public enum SpreadsheetFormat extends Enum<SpreadsheetFormat> implements IEnumValue
Defines various spreadsheet subformats.
Fields
| Field | Description |
|---|---|
| Unknown | The format is not recognized. |
| Xls | Represents the .XLS Excel format. |
| Xlsb | Represents the .XLSB Excel format. |
| Xlsx | Represents the .XLSX Excel format. |
| Xlsm | Represents the .XLSM Excel format. |
| Xltx | Represents the .XLTX Excel format. |
| Xltm | Represents the .XLTM Excel format. |
| Ods | Represents the Opendocument Spreadsheet format. |
| Xlt | Represents the .XLT Excel format. |
Methods
Unknown
public static final SpreadsheetFormat Unknown
The format is not recognized.
Xls
public static final SpreadsheetFormat Xls
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
public static final SpreadsheetFormat Xlsb
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
public static final SpreadsheetFormat Xlsx
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
public static final SpreadsheetFormat Xlsm
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
public static final SpreadsheetFormat Xltx
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
public static final SpreadsheetFormat Xltm
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
public static final SpreadsheetFormat Ods
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
public static final SpreadsheetFormat Xlt
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 .
values()
public static SpreadsheetFormat[] values()
Returns: com.groupdocs.metadata.core.SpreadsheetFormat[]
valueOf(String name)
public static SpreadsheetFormat valueOf(String name)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| name | java.lang.String |
Returns: SpreadsheetFormat
getByRawValue(int rawValue)
public static SpreadsheetFormat getByRawValue(int rawValue)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| rawValue | int |
Returns: SpreadsheetFormat
getFirst()
public static IEnumValue getFirst()
Returns: IEnumValue
getAllValues()
public Object[] getAllValues()
Returns the array of all values defined in the class.
Returns: java.lang.Object[]
getEnumValueByRawValue(int rawValue)
public IEnumValue getEnumValueByRawValue(int rawValue)
Returns the enumeration value by the raw value associated with it.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| rawValue | int |
Returns: IEnumValue
getEnumValueByName(String name)
public IEnumValue getEnumValueByName(String name)
Returns the enumeration value by its name.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| name | java.lang.String |
Returns: IEnumValue
getRawValueType()
public RawIntegerType getRawValueType()
Returns the underlying type of the raw value of this enumeration value.
Returns: RawIntegerType
getRawValue()
public int getRawValue()
Returns the raw value of this enumeration value.
Returns: int