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 and Description |
---|
EXCEL2007
Excel2007
The total number of available rows is 1M (2^20)
The total number of available columns is 16K (2^14)
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 rows is 64k (2^16)
The total number of available columns is 256 (2^8)
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 and 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 2021 The Apache Software Foundation or its licensors, as applicable.