Uses of Class
org.apache.poi.ss.util.CellAddress
-
Packages that use CellAddress Package Description org.apache.poi.hssf.usermodel usermodel package maps HSSF low level strutures to familiar workbook/sheet modelorg.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 -
-
Uses of CellAddress in org.apache.poi.hssf.usermodel
Methods in org.apache.poi.hssf.usermodel that return CellAddress Modifier and Type Method Description CellAddress
HSSFSheet. getActiveCell()
Return location of the active cell, e.g.CellAddress
HSSFCell. getAddress()
Gets the address of this cellCellAddress
HSSFComment. getAddress()
Methods in org.apache.poi.hssf.usermodel that return types with arguments of type CellAddress Modifier and Type Method Description java.util.Map<CellAddress,HSSFComment>
HSSFSheet. getCellComments()
Returns all cell comments on this sheet.Methods in org.apache.poi.hssf.usermodel with parameters of type CellAddress Modifier and Type Method Description HSSFComment
HSSFSheet. getCellComment(CellAddress ref)
Returns cell comment for the specified row and columnHSSFHyperlink
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 cellvoid
HSSFComment. setAddress(CellAddress address)
-
Uses of CellAddress in org.apache.poi.ss.usermodel
Methods in org.apache.poi.ss.usermodel that return CellAddress Modifier and Type Method Description CellAddress
Sheet. getActiveCell()
Return location of the active cell, e.g.CellAddress
Cell. getAddress()
Gets the address of this cellCellAddress
Comment. 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 CellAddress Modifier and Type Method Description java.util.Map<CellAddress,? extends Comment>
Sheet. getCellComments()
Returns all cell comments on this sheet.Methods in org.apache.poi.ss.usermodel with parameters of type CellAddress Modifier and Type Method Description Comment
Sheet. getCellComment(CellAddress ref)
Returns cell comment for the specified locationHyperlink
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 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 CellAddress Modifier and Type Field Description static 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 CellAddress Modifier and Type Method Description java.util.Iterator<CellAddress>
CellRangeAddressBase. 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 CellAddress Modifier and Type Method 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 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, java.lang.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 Constructor Description CellAddress(CellAddress address)
Create a new CellAddress object -
Uses of CellAddress in org.apache.poi.xssf.binary
Methods in org.apache.poi.xssf.binary that return types with arguments of type CellAddress Modifier and Type Method Description java.util.Queue<CellAddress>
XSSFBCommentsTable. getAddresses()
java.util.Map<CellAddress,java.util.List<XSSFHyperlinkRecord>>
XSSFBHyperlinksTable. getHyperLinks()
Methods in org.apache.poi.xssf.binary with parameters of type CellAddress Modifier and Type Method Description java.util.List<XSSFHyperlinkRecord>
XSSFBHyperlinksTable. 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 CellAddress Modifier and Type Method 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.usegetCellAddresses
insteadMethods in org.apache.poi.xssf.model with parameters of type CellAddress Modifier and Type Method Description XSSFComment
Comments. findCellComment(CellAddress cellAddress)
Finds the cell comment at cellAddress, if one existsXSSFComment
CommentsTable. 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 CellAddress Modifier and Type Method Description CellAddress
SXSSFSheet. getActiveCell()
Return location of the active cell, e.g.CellAddress
SXSSFCell. getAddress()
Gets the address of this cellMethods in org.apache.poi.xssf.streaming that return types with arguments of type CellAddress Modifier and Type Method Description java.util.Map<CellAddress,XSSFComment>
SXSSFSheet. getCellComments()
Returns all cell comments on this sheet.Methods in org.apache.poi.xssf.streaming with parameters of type CellAddress Modifier and Type Method Description XSSFComment
SXSSFSheet. getCellComment(CellAddress ref)
Returns cell comment for the specified row and columnXSSFHyperlink
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 -
Uses of CellAddress in org.apache.poi.xssf.usermodel
Methods in org.apache.poi.xssf.usermodel that return CellAddress Modifier and Type Method Description CellAddress
XSSFSheet. getActiveCell()
Return location of the active cell, e.g.CellAddress
XSSFCell. getAddress()
Gets the address of this cellCellAddress
XSSFComment. getAddress()
Methods in org.apache.poi.xssf.usermodel that return types with arguments of type CellAddress Modifier and Type Method Description java.util.Map<CellAddress,XSSFComment>
XSSFSheet. getCellComments()
Returns all cell comments on this sheet.Methods in org.apache.poi.xssf.usermodel with parameters of type CellAddress Modifier and Type Method 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 cellvoid
XSSFComment. setAddress(CellAddress address)
-