java.io.Serializable
, java.lang.Comparable<SpreadsheetVersion>
public enum SpreadsheetVersion extends java.lang.Enum<SpreadsheetVersion>
Properties of this enum correspond to attributes of the spreadsheet that are easily discernable to the user. It is not intended to deal with low-level issues like file formats.
Enum Constant | Description |
---|---|
EXCEL2007 |
Excel2007
The total number of available columns is 16K (2^14)
The total number of available rows is 1M (2^20)
The maximum number of arguments to a function is 255
Number of conditional format conditions on a cell is unlimited
(actually limited by available memory in Excel)
Number of cell styles is 64000
Length of text cell contents is 32767
|
EXCEL97 |
Excel97 format aka BIFF8
The total number of available columns is 256 (2^8)
The total number of available rows is 64k (2^16)
The maximum number of arguments to a function is 30
Number of conditional format conditions on a cell is 3
Number of cell styles is 4000
Length of text cell contents is 32767
|
Modifier and Type | Method | Description |
---|---|---|
int |
getLastColumnIndex() |
|
java.lang.String |
getLastColumnName() |
|
int |
getLastRowIndex() |
|
int |
getMaxCellStyles() |
|
int |
getMaxColumns() |
|
int |
getMaxConditionalFormats() |
|
int |
getMaxFunctionArgs() |
|
int |
getMaxRows() |
|
int |
getMaxTextLength() |
|
static SpreadsheetVersion |
valueOf(java.lang.String name) |
Returns the enum constant of this type with the specified name.
|
static SpreadsheetVersion[] |
values() |
Returns an array containing the constants of this enum type, in
the order they are declared.
|
public static final SpreadsheetVersion EXCEL97
public static final SpreadsheetVersion EXCEL2007
public static SpreadsheetVersion[] values()
for (SpreadsheetVersion c : SpreadsheetVersion.values()) System.out.println(c);
public static SpreadsheetVersion valueOf(java.lang.String name)
name
- the name of the enum constant to be returned.java.lang.IllegalArgumentException
- if this enum type has no constant with the specified namejava.lang.NullPointerException
- if the argument is nullpublic int getMaxRows()
public int getLastRowIndex()
getMaxRows() - 1
public int getMaxColumns()
public int getLastColumnIndex()
getMaxColumns() - 1
public int getMaxFunctionArgs()
public int getMaxConditionalFormats()
public int getMaxCellStyles()
public java.lang.String getLastColumnName()
IV
or XFD
).public int getMaxTextLength()
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.