Uses of Class
org.apache.poi.ss.util.CellAddress
Packages that use CellAddress
Package
Description
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
The org.apache.poi.xssf.binary package includes necessary underlying components
for streaming/read-only processing of xlsb files.
-
Uses of CellAddress in org.apache.poi.hssf.usermodel
Methods in org.apache.poi.hssf.usermodel that return CellAddressModifier and TypeMethodDescriptionHSSFSheet.getActiveCell()
Return location of the active cell, e.g.HSSFCell.getAddress()
Gets the address of this cellHSSFComment.getAddress()
Methods in org.apache.poi.hssf.usermodel that return types with arguments of type CellAddressModifier and TypeMethodDescriptionHSSFSheet.getCellComments()
Returns all cell comments on this sheet.Methods in org.apache.poi.hssf.usermodel with parameters of type CellAddressModifier and TypeMethodDescriptionHSSFSheet.getCellComment
(CellAddress ref) Returns cell comment for the specified row and columnHSSFSheet.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 cellvoid
HSSFComment.setAddress
(CellAddress address) -
Uses of CellAddress in org.apache.poi.ss.usermodel
Methods in org.apache.poi.ss.usermodel that return CellAddressModifier and TypeMethodDescriptionSheet.getActiveCell()
Return location of the active cell, e.g.Cell.getAddress()
Gets the address of this cellComment.getAddress()
Get the address of the cell that this comment is attached toMethods in org.apache.poi.ss.usermodel that return types with arguments of type CellAddressModifier and TypeMethodDescriptionMap
<CellAddress, ? extends Comment> Sheet.getCellComments()
Returns all cell comments on this sheet.Methods in org.apache.poi.ss.usermodel with parameters of type CellAddressModifier and TypeMethodDescriptionSheet.getCellComment
(CellAddress ref) Returns cell comment for the specified locationSheet.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 cellvoid
Comment.setAddress
(CellAddress addr) Set the address of the cell that this comment is attached to -
Uses of CellAddress in org.apache.poi.ss.util
Fields in org.apache.poi.ss.util declared as CellAddressModifier and TypeFieldDescriptionstatic final CellAddress
CellAddress.A1
A constant for references to the first cell in a sheet.Methods in org.apache.poi.ss.util that return types with arguments of type CellAddressModifier and TypeMethodDescriptionCellRangeAddressBase.iterator()
Returns an iterator over the CellAddresses in this cell range in row-major order.Methods in org.apache.poi.ss.util with parameters of type CellAddressModifier and TypeMethodDescriptionint
CellAddress.compareTo
(CellAddress other) Compare this CellAddress using the "natural" row-major, column-minor ordering.PropertyTemplate.getBorderStyle
(CellAddress cell, String property) Retrieves the border style for a given cellint
PropertyTemplate.getNumBorderColors
(CellAddress cell) Retrieves the number of border colors assigned to a cellint
PropertyTemplate.getNumBorders
(CellAddress cell) Retrieves the number of borders assigned to a cellshort
PropertyTemplate.getTemplateProperty
(CellAddress cell, String property) Retrieves the border style for a given cellboolean
CellRangeAddressBase.isInRange
(CellAddress ref) Determines if the givenCellAddress
lies within the bounds of this range.Constructors in org.apache.poi.ss.util with parameters of type CellAddress -
Uses of CellAddress in org.apache.poi.xssf.binary
Methods in org.apache.poi.xssf.binary that return types with arguments of type CellAddressModifier and TypeMethodDescriptionXSSFBCommentsTable.getAddresses()
XSSFBHyperlinksTable.getHyperLinks()
Methods in org.apache.poi.xssf.binary with parameters of type CellAddressModifier and TypeMethodDescriptionXSSFBHyperlinksTable.findHyperlinkRecord
(CellAddress cellAddress) org.apache.poi.xssf.binary.XSSFBComment
XSSFBCommentsTable.get
(CellAddress cellAddress) -
Uses of CellAddress in org.apache.poi.xssf.model
Methods in org.apache.poi.xssf.model that return types with arguments of type CellAddressModifier and TypeMethodDescriptionComments.getCellAddresses()
Returns all cell addresses that have comments.CommentsTable.getCellAddresses()
Returns all cell addresses that have comments.CommentsTable.getCellComments()
Deprecated.Methods in org.apache.poi.xssf.model with parameters of type CellAddressModifier and TypeMethodDescriptionComments.findCellComment
(CellAddress cellAddress) Finds the cell comment at cellAddress, if one existsCommentsTable.findCellComment
(CellAddress cellAddress) Finds the cell comment at cellAddress, if one existsorg.openxmlformats.schemas.spreadsheetml.x2006.main.CTComment
CommentsTable.getCTComment
(CellAddress cellRef) Get the underlying CTComment xmlbean for a comment located at cellRef, if it existsorg.openxmlformats.schemas.spreadsheetml.x2006.main.CTComment
CommentsTable.newComment
(CellAddress ref) Create a new comment located` at cell addressvoid
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 cacheboolean
Comments.removeComment
(CellAddress cellRef) Remove the comment at cellRef location, if one existsboolean
CommentsTable.removeComment
(CellAddress cellRef) Remove the comment at cellRef location, if one exists -
Uses of CellAddress in org.apache.poi.xssf.streaming
Methods in org.apache.poi.xssf.streaming that return CellAddressModifier and TypeMethodDescriptionSXSSFSheet.getActiveCell()
Return location of the active cell, e.g.SXSSFCell.getAddress()
Gets the address of this cellMethods in org.apache.poi.xssf.streaming that return types with arguments of type CellAddressModifier and TypeMethodDescriptionSXSSFSheet.getCellComments()
Returns all cell comments on this sheet.Methods in org.apache.poi.xssf.streaming with parameters of type CellAddressModifier and TypeMethodDescriptionSXSSFSheet.getCellComment
(CellAddress ref) Returns cell comment for the specified row and columnSXSSFSheet.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 -
Uses of CellAddress in org.apache.poi.xssf.usermodel
Methods in org.apache.poi.xssf.usermodel that return CellAddressModifier and TypeMethodDescriptionXSSFSheet.getActiveCell()
Return location of the active cell, e.g.XSSFCell.getAddress()
Gets the address of this cellXSSFComment.getAddress()
Methods in org.apache.poi.xssf.usermodel that return types with arguments of type CellAddressModifier and TypeMethodDescriptionXSSFSheet.getCellComments()
Returns all cell comments on this sheet.Methods in org.apache.poi.xssf.usermodel with parameters of type CellAddressModifier and TypeMethodDescriptionXSSFSheet.getCellComment
(CellAddress address) Return cell comment at row, column, if one exists.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 cellvoid
XSSFComment.setAddress
(CellAddress address)
getCellAddresses
instead