| Package | Description |
|---|---|
| org.apache.poi.hssf.usermodel |
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
|
| org.apache.poi.ss.usermodel | |
| org.apache.poi.ss.util |
| Modifier and Type | Method and Description |
|---|---|
CellAddress |
HSSFSheet.getActiveCell()
Return location of the active cell, e.g.
|
CellAddress |
HSSFComment.getAddress() |
| Modifier and Type | Method and Description |
|---|---|
Map<CellAddress,HSSFComment> |
HSSFSheet.getCellComments()
Returns all cell comments on this sheet.
|
| Modifier and Type | Method and Description |
|---|---|
HSSFComment |
HSSFSheet.getCellComment(CellAddress ref)
Returns cell comment for the specified row and column
|
HSSFHyperlink |
HSSFSheet.getHyperlink(CellAddress addr)
Get a Hyperlink in this sheet located in a cell specified by {code addr}
|
void |
HSSFSheet.setActiveCell(CellAddress address)
Sets location of the active cell
|
void |
HSSFComment.setAddress(CellAddress address) |
| Modifier and Type | Method and Description |
|---|---|
CellAddress |
Sheet.getActiveCell()
Return location of the active cell, e.g.
|
CellAddress |
Comment.getAddress()
Get the address of the cell that this comment is attached to
|
CellAddress |
Cell.getAddress()
Gets the address of this cell
|
CellAddress |
CellBase.getAddress()
Gets the address of this cell
|
| Modifier and Type | Method and Description |
|---|---|
Map<CellAddress,? extends Comment> |
Sheet.getCellComments()
Returns all cell comments on this sheet.
|
| Modifier and Type | Method and Description |
|---|---|
Comment |
Sheet.getCellComment(CellAddress ref)
Returns cell comment for the specified location
|
Hyperlink |
Sheet.getHyperlink(CellAddress addr)
Get a Hyperlink in this sheet located in a cell specified by {code addr}
|
void |
Sheet.setActiveCell(CellAddress address)
Sets location of the active cell
|
void |
Comment.setAddress(CellAddress addr)
Set the address of the cell that this comment is attached to
|
| Modifier and Type | Field and Description |
|---|---|
static CellAddress |
CellAddress.A1
A constant for references to the first cell in a sheet.
|
| Modifier and Type | Method and Description |
|---|---|
Iterator<CellAddress> |
CellRangeAddressBase.iterator()
Returns an iterator over the CellAddresses in this cell range in row-major order.
|
Spliterator<CellAddress> |
CellRangeAddressBase.spliterator()
Returns a spliterator over the CellAddresses in this cell range in row-major order.
|
| Modifier and Type | Method and Description |
|---|---|
int |
CellAddress.compareTo(CellAddress other)
Compare this CellAddress using the "natural" row-major, column-minor ordering.
|
BorderStyle |
PropertyTemplate.getBorderStyle(CellAddress cell,
CellPropertyType property)
Retrieves the border style for a given cell
|
BorderStyle |
PropertyTemplate.getBorderStyle(CellAddress cell,
String propertyName)
Deprecated.
|
int |
PropertyTemplate.getNumBorderColors(CellAddress cell)
Retrieves the number of border colors assigned to a cell
|
int |
PropertyTemplate.getNumBorders(CellAddress cell)
Retrieves the number of borders assigned to a cell
|
short |
PropertyTemplate.getTemplateProperty(CellAddress cell,
CellPropertyType property)
Retrieves the border style for a given cell
|
short |
PropertyTemplate.getTemplateProperty(CellAddress cell,
String propertyName)
|
boolean |
CellRangeAddressBase.isInRange(CellAddress ref)
Determines if the given
CellAddress lies within the bounds
of this range. |
| Constructor and Description |
|---|
CellAddress(CellAddress address)
Create a new CellAddress object
|