SpreadsheetFormat

Contents
[ ]

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

Method Description
values()
valueOf(String name)
getByRawValue(int rawValue)
getFirst()
getAllValues()
getEnumValueByRawValue(int rawValue)
getEnumValueByName(String name)
getRawValueType()
getRawValue()

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