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.
(这个枚举允许来自多个 Excel 版本的电子表格由公共代码处理。该枚举的属性对应于用户容易辨别的电子表格的属性。它的目的不是处理文件格式等低级问题。)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);(按照声明的顺序返回包含此枚举类型常量的数组。此方法可用于迭代常量,如下所示: 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.
(name - 要返回的枚举常量的名称。)
java.lang.IllegalArgumentException
- if this enum type has no constant with the specified name
(java.lang.IllegalArgumentException - 如果此枚举类型没有具有指定名称的常量)
java.lang.NullPointerException
- if the argument is null
(java.lang.NullPointerException - 如果参数为空)
public int getMaxRows()
public int getLastRowIndex()
getMaxRows() - 1
(最后(最大)有效行索引,等于 getMaxRows() - 1)
public int getMaxColumns()
public int getLastColumnIndex()
getMaxColumns() - 1
(最后一个(最大)有效列索引,等于 getMaxColumns() - 1)
public int getMaxFunctionArgs()
public int getMaxConditionalFormats()
public int getMaxCellStyles()
public java.lang.String getLastColumnName()
IV
or
XFD
).
(ALPHA-26 表示(IV 或 XFD)中的最后一个有效列索引。)
public int getMaxTextLength()
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.