public enum SpreadsheetFormat extends Enum<SpreadsheetFormat> implements IEnumValue
Defines various spreadsheet subformats.
Enum Constant and Description |
---|
Ods
Represents the Opendocument Spreadsheet format.
|
Unknown
The format is not recognized.
|
Xls
Represents the .XLS Excel format.
|
Xlsb
Represents the .XLSB Excel format.
|
Xlsm
Represents the .XLSM Excel format.
|
Xlsx
Represents the .XLSX Excel format.
|
Xlt
Represents the .XLT Excel format.
|
Xltm
Represents the .XLTM Excel format.
|
Xltx
Represents the .XLTX Excel format.
|
Modifier and Type | Method and Description |
---|---|
Object[] |
getAllValues()
Returns the array of all values defined in the class.
|
static SpreadsheetFormat |
getByRawValue(int rawValue) |
IEnumValue |
getEnumValueByName(String name)
Returns the enumeration value by its name.
|
IEnumValue |
getEnumValueByRawValue(int rawValue)
Returns the enumeration value by the raw value associated with it.
|
static IEnumValue |
getFirst() |
int |
getRawValue()
Returns the raw value of this enumeration value.
|
RawIntegerType |
getRawValueType()
Returns the underlying type of the raw value of this enumeration value.
|
static SpreadsheetFormat |
valueOf(String name)
Returns the enum constant of this type with the specified name.
|
static SpreadsheetFormat[] |
values()
Returns an array containing the constants of this enum type, in
the order they are declared.
|
compareTo, equals, getDeclaringClass, hashCode, name, ordinal, toString, valueOf
name
public static final SpreadsheetFormat Unknown
The format is not recognized.
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 <a target="_blank" href="https://wiki.fileformat.com/spreadsheet/xls/">here</a>
.
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 <a target="_blank" href="https://wiki.fileformat.com/spreadsheet/xlsb/">here</a>
.
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 <a target="_blank" href="https://wiki.fileformat.com/spreadsheet/xlsx/">here</a>
.
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 <a target="_blank" href="https://wiki.fileformat.com/spreadsheet/xlsm/">here</a>
.
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 <a target="_blank" href="https://wiki.fileformat.com/spreadsheet/xltx/">here</a>
.
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 <a target="_blank" href="https://wiki.fileformat.com/spreadsheet/xltm/">here</a>
.
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 <a target="_blank" href="https://wiki.fileformat.com/spreadsheet/ods/">here</a>
.
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 <a target="_blank" href="https://wiki.fileformat.com/spreadsheet/xlt/">here</a>
.
public static SpreadsheetFormat[] values()
for (SpreadsheetFormat c : SpreadsheetFormat.values()) System.out.println(c);
public static SpreadsheetFormat valueOf(String name)
name
- the name of the enum constant to be returned.IllegalArgumentException
- if this enum type has no constant with the specified nameNullPointerException
- if the argument is nullpublic static SpreadsheetFormat getByRawValue(int rawValue)
public static IEnumValue getFirst()
public Object[] getAllValues()
IEnumValue
Returns the array of all values defined in the class.
getAllValues
in interface IEnumValue
public IEnumValue getEnumValueByRawValue(int rawValue)
IEnumValue
Returns the enumeration value by the raw value associated with it.
getEnumValueByRawValue
in interface IEnumValue
rawValue
- The raw value.public IEnumValue getEnumValueByName(String name)
IEnumValue
Returns the enumeration value by its name.
getEnumValueByName
in interface IEnumValue
name
- The name of the enumeration value.public RawIntegerType getRawValueType()
IEnumValue
Returns the underlying type of the raw value of this enumeration value.
getRawValueType
in interface IEnumValue
public int getRawValue()
IEnumValue
Returns the raw value of this enumeration value.
getRawValue
in interface IEnumValue