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, 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)
@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.