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.
|
containsColumn, containsRow, equals, getFirstColumn, getFirstRow, getLastColumn, getLastRow, getMaxColumn, getMaxRow, getMinColumn, getMinRow, getNumberOfCells, getPosition, hashCode, intersects, isFullColumnRange, isFullRowRange, isInRange, isInRange, isInRange, isInRange, iterator, setFirstColumn, setFirstRow, setLastColumn, setLastRow, toString, validate
public static final int ENCODED_SIZE
public CellRangeAddress(int firstRow, int lastRow, int firstCol, int lastCol)
firstRow
- Index of first rowlastRow
- Index of last row (inclusive), must be equal to or larger than firstRow
firstCol
- Index of first columnlastCol
- Index of last column (inclusive), must be equal to or larger than 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")Copyright 2020 The Apache Software Foundation or its licensors, as applicable.