public class CellAddress extends java.lang.Object implements java.lang.Comparable<CellAddress>
This class is a container for POI usermodel row=0 column=0 cell references. It is barely a container for these two coordinates. The implementation of the Comparable interface sorts by "natural" order top left to bottom right.
Use CellAddress
when you want to refer to the location of a cell in a sheet
when the concept of relative/absolute does not apply (such as the anchor location
of a cell comment). Use CellReference
when the concept of
relative/absolute does apply (such as a cell reference in a formula).
CellAddress
es do not have a concept of "sheet", while CellReference
s do.
Modifier and Type | Field and Description |
---|---|
static CellAddress |
A1
A constant for references to the first cell in a sheet.
|
Constructor and Description |
---|
CellAddress(Cell cell)
Create a new CellAddress object.
|
CellAddress(CellAddress address)
Create a new CellAddress object
|
CellAddress(CellReference reference)
Create a new CellAddress object.
|
CellAddress(int row,
int column)
Create a new CellAddress object.
|
CellAddress(java.lang.String address)
Create a new CellAddress object.
|
Modifier and Type | Method and Description |
---|---|
int |
compareTo(CellAddress other)
Compare this CellAddress using the "natural" row-major, column-minor ordering.
|
boolean |
equals(java.lang.Object o) |
java.lang.String |
formatAsR1C1String() |
java.lang.String |
formatAsString()
Same as
toString() |
int |
getColumn()
Get the cell address column
|
int |
getRow()
Get the cell address row
|
int |
hashCode() |
java.lang.String |
toString() |
public static final CellAddress A1
public CellAddress(int row, int column)
row
- Row index (first row is 0)column
- Column index (first column is 0)public CellAddress(java.lang.String address)
address
- a cell address in A1 format. Address may not contain sheet name or dollar signs.
(that is, address is not a cell reference. Use CellAddress(CellReference)
instead if
starting with a cell reference.)public CellAddress(CellReference reference)
reference
- a reference to a cellpublic CellAddress(CellAddress address)
address
- a CellAddresspublic CellAddress(Cell cell)
cell
- the Cell to get the location ofpublic int getRow()
public int getColumn()
public int compareTo(CellAddress other)
compareTo
in interface java.lang.Comparable<CellAddress>
public boolean equals(java.lang.Object o)
equals
in class java.lang.Object
public int hashCode()
hashCode
in class java.lang.Object
public java.lang.String toString()
toString
in class java.lang.Object
public java.lang.String formatAsString()
toString()
public java.lang.String formatAsR1C1String()
formatAsString()
Copyright 2022 The Apache Software Foundation or its licensors, as applicable.