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 | |
org.apache.poi.xssf.binary |
The org.apache.poi.xssf.binary package includes necessary underlying components
for streaming/read-only processing of xlsb files.
|
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 |
HSSFComment.getAddress() |
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
|
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 |
---|---|
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
|
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 |
---|---|
java.util.Iterator<CellAddress> |
CellRangeAddressBase.iterator()
Returns an iterator 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,
java.lang.String property)
Retrieves the border style for a given cell
|
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,
java.lang.String property)
Retrieves the border style for a given cell
|
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
|
Modifier and Type | Method and Description |
---|---|
java.util.Queue<CellAddress> |
XSSFBCommentsTable.getAddresses() |
java.util.Map<CellAddress,java.util.List<XSSFHyperlinkRecord>> |
XSSFBHyperlinksTable.getHyperLinks() |
Modifier and Type | Method and Description |
---|---|
java.util.List<XSSFHyperlinkRecord> |
XSSFBHyperlinksTable.findHyperlinkRecord(CellAddress cellAddress) |
org.apache.poi.xssf.binary.XSSFBComment |
XSSFBCommentsTable.get(CellAddress cellAddress) |
Modifier and Type | Method and Description |
---|---|
java.util.Iterator<CellAddress> |
Comments.getCellAddresses()
Returns all cell addresses that have comments.
|
java.util.Iterator<CellAddress> |
CommentsTable.getCellAddresses()
Returns all cell addresses that have comments.
|
java.util.Map<CellAddress,XSSFComment> |
CommentsTable.getCellComments()
Deprecated.
use
getCellAddresses instead |
Modifier and Type | Method and Description |
---|---|
XSSFComment |
Comments.findCellComment(CellAddress cellAddress)
Finds the cell comment at cellAddress, if one exists
|
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 |
Comments.removeComment(CellAddress cellRef)
Remove the comment at cellRef location, if one exists
|
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.
|
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
|
XSSFHyperlink |
SXSSFSheet.getHyperlink(CellAddress addr)
Get a Hyperlink in this sheet located in a cell specified by {code addr}
|
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 |
XSSFComment.getAddress() |
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.
|
XSSFHyperlink |
XSSFSheet.getHyperlink(CellAddress addr)
Get a Hyperlink in this sheet located in a cell specified by {code addr}
|
void |
XSSFSheet.setActiveCell(CellAddress address)
Sets location of the active cell
|
void |
XSSFComment.setAddress(CellAddress address) |
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.