Package io.keikai.api

Enum Class SpreadsheetVersion

java.lang.Object

java.lang.Enum<SpreadsheetVersion>

io.keikai.api.SpreadsheetVersion

All Implemented Interfaces:

Serializable, Comparable<SpreadsheetVersion>, Constable

public enum SpreadsheetVersion
extends Enum<SpreadsheetVersion>

Workbook format version. Keikai 7.0 only authors and reads OOXML (Excel 2007+); legacy BIFF8 (Excel 97-2003) sizes are kept as constants for backwards-compatible API enumeration only.

Since:

7.0.0

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

Enum Constant Summary

Enum Constants

Enum Constant	Description
EXCEL2007	Excel 2007+ (OOXML).
EXCEL97	Excel 97-2003 (BIFF8).

Method Summary

Modifier and Type	Method	Description
int	getLastColumnIndex()
int	getLastRowIndex()
int	getMaxColumns()
int	getMaxRows()
static SpreadsheetVersion	valueOf(String name)	Returns the enum constant of this class with the specified name.
static SpreadsheetVersion[]	values()	Returns an array containing the constants of this enum class, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

EXCEL97

public static final SpreadsheetVersion EXCEL97

Excel 97-2003 (BIFF8). 65,536 rows x 256 columns.

EXCEL2007

public static final SpreadsheetVersion EXCEL2007

Excel 2007+ (OOXML). 1,048,576 rows x 16,384 columns.

Method Details

values

public static SpreadsheetVersion[] values()

Returns an array containing the constants of this enum class, in the order they are declared.

Returns:

an array containing the constants of this enum class, in the order they are declared

valueOf

public static SpreadsheetVersion valueOf(String name)

Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum class has no constant with the specified name

NullPointerException - if the argument is null

getMaxRows

public int getMaxRows()

Returns:

the maximum number of rows supported by this version.

getLastRowIndex

public int getLastRowIndex()

Returns:

the highest valid 0-based row index (getMaxRows() - 1).

getMaxColumns

public int getMaxColumns()

Returns:

the maximum number of columns supported by this version.

getLastColumnIndex

public int getLastColumnIndex()

Returns:

the highest valid 0-based column index (getMaxColumns() - 1).