| Modifier and Type | Method and Description |
|---|---|
Cell |
get(CellIndex index)
Gets a
Cell object that can be used to manipulate the data of the specified cell. |
Cell |
get(int column,
int row)
Gets a
Cell object that can be used to manipulate the data of the cell with the specified coordinates. |
Cell |
get(java.lang.String reference)
Gets a
Cell object that can be used to manipulate the data of the specified cell. |
java.util.Iterator<Cell> |
iterator()
Returns an object that iterates through the collection.
|
public java.util.Iterator<Cell> iterator()
The returned enumerator iterates only though the cells that are not blank.
iterator in interface java.lang.Iterable<Cell>Iterator that can be used to iterate through the collection.public Cell get(int column, int row)
Cell object that can be used to manipulate the data of the cell with the specified coordinates.column - The zero-based index of the cell column.row - The zero-based index of the cell row.Cell object that can be used to get or set the data of the cell.public Cell get(java.lang.String reference)
Cell object that can be used to manipulate the data of the specified cell.
If reference is not a valid cell reference, represents a cell range, or contains
a sheet name other than that of the current worksheet, this property returns null.
reference - A string value representing a cell reference in the A1 or R1C1 format.Cell object that can be used to get or set the data of the cell.