public class CellRangeAddress extends CellRangeAddressBase
In the Microsoft documentation, this is also known as a Ref8U - see page 831 of version 1.0 of the documentation. Note - SelectionRecord
uses the BIFF5 version of this structure
CellRangeAddressBase.CellPosition
Modifier and Type | Field and Description |
---|---|
static int |
ENCODED_SIZE |
Constructor and Description |
---|
CellRangeAddress(int firstRow, int lastRow, int firstCol, int lastCol)
Creates new cell range.
|
CellRangeAddress(RecordInputStream in) |
Modifier and Type | Method and Description |
---|---|
CellRangeAddress |
copy() |
java.lang.String |
formatAsString() |
java.lang.String |
formatAsString(java.lang.String sheetName, boolean useAbsoluteAddress) |
static int |
getEncodedSize(int numberOfItems) |
void |
serialize(LittleEndianOutput out) |
static CellRangeAddress |
valueOf(java.lang.String ref)
Creates a CellRangeAddress from a cell range reference string.
(从单元格区域引用字符串创建 CellRangeAddress。)
|
containsColumn, containsRow, equals, getFirstColumn, getFirstRow, getGenericProperties, getLastColumn, getLastRow, getMaxColumn, getMaxRow, getMinColumn, getMinRow, getNumberOfCells, getPosition, hashCode, intersects, isFullColumnRange, isFullRowRange, isInRange, isInRange, isInRange, isInRange, iterator, setFirstColumn, setFirstRow, setLastColumn, setLastRow, toString, validate
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
getGenericChildren, getGenericRecordType
public static final int ENCODED_SIZE
public CellRangeAddress(int firstRow, int lastRow, int firstCol, int lastCol)
firstRow
- Index of first row
(firstRow - 第一行的索引)
lastRow
- Index of last row (inclusive), must be equal to or larger than
firstRow
(lastRow - 最后一行的索引(包括),必须等于或大于 firstRow)
firstCol
- Index of first column
(firstCol - 第一列的索引)
lastCol
- Index of last column (inclusive), must be equal to or larger than
firstCol
(lastCol - 最后一列(含)的索引,必须等于或大于 firstCol)
public CellRangeAddress(RecordInputStream in)
public void serialize(LittleEndianOutput out)
public CellRangeAddress copy()
public static int getEncodedSize(int numberOfItems)
public java.lang.String formatAsString()
public java.lang.String formatAsString(java.lang.String sheetName, boolean useAbsoluteAddress)
public static CellRangeAddress valueOf(java.lang.String ref)
ref
- usually a standard area ref (e.g. "B1:D8"). May be a single cell ref (e.g. "B5") in which case the result is a 1 x 1 cell range. May also be a whole row range (e.g. "3:5"), or a whole column range (e.g. "C:F")
(ref - 通常是标准区域 ref(例如“B1:D8”)。可能是单个单元格引用(例如“B5”),在这种情况下,结果是 1 x 1 单元格范围。也可以是整个行范围(例如“3:5”)或整个列范围(例如“C:F”))
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.