Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.apache.poi.ss.usermodel | |
org.apache.poi.ss.util | |
org.apache.poi.xssf.model | |
org.apache.poi.xssf.streaming | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Method and Description |
---|---|
CellAddress |
HSSFSheet.getActiveCell()
Return location of the active cell, e.g.
|
CellAddress |
HSSFCell.getAddress()
Gets the address of this cell
|
Modifier and Type | Method and Description |
---|---|
java.util.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
|
void |
HSSFSheet.setActiveCell(CellAddress address)
Sets location of the active cell
|
Modifier and Type | Method and Description |
---|---|
CellAddress |
Sheet.getActiveCell()
Return location of the active cell, e.g.
|
CellAddress |
Cell.getAddress()
Gets the address of this cell
|
Modifier and Type | Method and Description |
---|---|
java.util.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
|
void |
Sheet.setActiveCell(CellAddress address)
Sets location of the active cell
|
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 |
---|---|
int |
CellAddress.compareTo(CellAddress other)
Compare this CellAddress using the "natural" row-major, column-minor ordering.
|
Modifier and Type | Method and Description |
---|---|
java.util.Map<CellAddress,XSSFComment> |
CommentsTable.getCellComments()
Returns all cell comments on this sheet.
|
Modifier and Type | Method and Description |
---|---|
XSSFComment |
CommentsTable.findCellComment(CellAddress cellAddress)
Finds the cell comment at cellAddress, if one exists
|
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTComment |
CommentsTable.getCTComment(CellAddress cellRef)
Get the underlying CTComment xmlbean for a comment located at cellRef, if it exists
|
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTComment |
CommentsTable.newComment(CellAddress ref)
Create a new comment located` at cell address
|
void |
CommentsTable.referenceUpdated(CellAddress oldReference,
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTComment comment)
Called after the reference is updated, so that
we can reflect that in our cache
|
boolean |
CommentsTable.removeComment(CellAddress cellRef)
Remove the comment at cellRef location, if one exists
|
Modifier and Type | Method and Description |
---|---|
CellAddress |
SXSSFSheet.getActiveCell()
Return location of the active cell, e.g.
|
CellAddress |
SXSSFCell.getAddress()
Gets the address of this cell
|
Modifier and Type | Method and Description |
---|---|
java.util.Map<CellAddress,XSSFComment> |
SXSSFSheet.getCellComments()
Returns all cell comments on this sheet.
|
Modifier and Type | Method and Description |
---|---|
XSSFComment |
SXSSFSheet.getCellComment(CellAddress ref)
Returns cell comment for the specified row and column
|
void |
SXSSFSheet.setActiveCell(CellAddress address)
Sets location of the active cell
|
Modifier and Type | Method and Description |
---|---|
CellAddress |
XSSFSheet.getActiveCell()
Return location of the active cell, e.g.
|
CellAddress |
XSSFCell.getAddress()
Gets the address of this cell
|
Modifier and Type | Method and Description |
---|---|
java.util.Map<CellAddress,XSSFComment> |
XSSFSheet.getCellComments()
Returns all cell comments on this sheet.
|
Modifier and Type | Method and Description |
---|---|
XSSFComment |
XSSFSheet.getCellComment(CellAddress address)
Return cell comment at row, column, if one exists.
|
void |
XSSFSheet.setActiveCell(CellAddress address)
Sets location of the active cell
|
Copyright 2016 The Apache Software Foundation or its licensors, as applicable.