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
| 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) |
int |
serialize(int offset,
byte[] data)
Deprecated.
|
void |
serialize(LittleEndianOutput out) |
static CellRangeAddress |
valueOf(java.lang.String ref)
Creates a CellRangeAddress from a cell range reference string.
|
equals, getFirstColumn, getFirstRow, getLastColumn, getLastRow, getMaxColumn, getMaxRow, getMinColumn, getMinRow, getNumberOfCells, hashCode, intersects, isFullColumnRange, isFullRowRange, isInRange, setFirstColumn, setFirstRow, setLastColumn, setLastRow, toString, validatepublic 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 firstRowfirstCol - Index of first columnlastCol - Index of last column (inclusive), must be equal to or larger than firstColpublic CellRangeAddress(RecordInputStream in)
@Deprecated
public int serialize(int offset,
byte[] data)
serialize(LittleEndianOutput)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 2017 The Apache Software Foundation or its licensors, as applicable.