| Modifier and Type | Class and Description |
|---|---|
class |
SXSSFRow.CellIterator
returns all cells including empty cells in which case "null" is returned
|
class |
SXSSFRow.FilledCellIterator
returns all filled cells (created via Row.createCell())
|
Row.MissingCellPolicyCREATE_NULL_AS_BLANK, RETURN_BLANK_AS_NULL, RETURN_NULL_AND_BLANK| Constructor and Description |
|---|
SXSSFRow(SXSSFSheet sheet,
int initialSize) |
| Modifier and Type | Method and Description |
|---|---|
Iterator<Cell> |
allCellsIterator() |
Iterator<Cell> |
cellIterator() |
Cell |
createCell(int column)
Use this to create new cells within the row and return it.
|
Cell |
createCell(int column,
int type)
Use this to create new cells within the row and return it.
|
Cell |
getCell(int cellnum)
Get the cell representing a given column (logical cell) 0-based.
|
Cell |
getCell(int cellnum,
Row.MissingCellPolicy policy)
Returns the cell at the given (0 based) index, with the specified
Row.MissingCellPolicy |
Boolean |
getCollapsed() |
short |
getFirstCellNum()
Get the number of the first cell contained in this row.
|
short |
getHeight()
Get the row's height measured in twips (1/20th of a point).
|
float |
getHeightInPoints()
Returns row height measured in point size.
|
Boolean |
getHidden() |
short |
getLastCellNum()
Gets the index of the last cell contained in this row PLUS ONE.
|
int |
getPhysicalNumberOfCells()
Gets the number of defined cells (NOT number of cells in the actual row!).
|
int |
getRowNum()
Get row number this row represents
|
CellStyle |
getRowStyle()
Returns the whole-row cell style.
|
Sheet |
getSheet()
Returns the Sheet this row belongs to
|
boolean |
getZeroHeight()
Get whether or not to display this row with 0 height
|
boolean |
hasCustomHeight() |
boolean |
isFormatted()
Is this row formatted? Most aren't, but some rows
do have whole-row styles.
|
Iterator<Cell> |
iterator() |
void |
removeCell(Cell cell)
Remove the Cell from this row.
|
void |
setCollapsed(Boolean collapsed) |
void |
setHeight(short height)
Set the row's height or set to ff (-1) for undefined/default-height.
|
void |
setHeightInPoints(float height)
Set the row's height in points.
|
void |
setHidden(Boolean hidden) |
void |
setRowNum(int rowNum)
Set the row number of this row.
|
void |
setRowStyle(CellStyle style)
Applies a whole-row cell styling to the row.
|
void |
setZeroHeight(boolean zHeight)
Set whether or not to display this row with 0 height
|
public SXSSFRow(SXSSFSheet sheet, int initialSize)
public boolean hasCustomHeight()
public Boolean getHidden()
public void setHidden(Boolean hidden)
public Boolean getCollapsed()
public void setCollapsed(Boolean collapsed)
public Cell createCell(int column)
The cell that is returned is a Cell.CELL_TYPE_BLANK. The type can be changed
either through calling setCellValue or setCellType.
createCell in interface Rowcolumn - - the column number this cell representsIllegalArgumentException - if columnIndex < 0 or greater than the maximum number of supported columns
(255 for *.xls, 1048576 for *.xlsx)public Cell createCell(int column, int type)
The cell that is returned is a Cell.CELL_TYPE_BLANK. The type can be changed
either through calling setCellValue or setCellType.
createCell in interface Rowcolumn - - the column number this cell representsIllegalArgumentException - if columnIndex < 0 or greate than a maximum number of supported columns
(255 for *.xls, 1048576 for *.xlsx)public void removeCell(Cell cell)
removeCell in interface Rowcell - the cell to removepublic void setRowNum(int rowNum)
setRowNum in interface RowrowNum - the row number (0-based)IllegalArgumentException - if rowNum < 0public int getRowNum()
public Cell getCell(int cellnum)
getCell in interface Rowcellnum - 0 based column numbergetCell(int, org.apache.poi.ss.usermodel.Row.MissingCellPolicy)public Cell getCell(int cellnum, Row.MissingCellPolicy policy)
Row.MissingCellPolicygetCell in interface RowIllegalArgumentException - if cellnum < 0 or the specified MissingCellPolicy is invalidRow.RETURN_NULL_AND_BLANK,
Row.RETURN_BLANK_AS_NULL,
Row.CREATE_NULL_AS_BLANKpublic short getFirstCellNum()
getFirstCellNum in interface Rowpublic short getLastCellNum()
short minColIx = row.getFirstCellNum();
short maxColIx = row.getLastCellNum();
for(short colIx=minColIx; colIx<maxColIx; colIx++) {
Cell cell = row.getCell(colIx);
if(cell == null) {
continue;
}
//... do something with cell
}
getLastCellNum in interface Rowpublic int getPhysicalNumberOfCells()
getPhysicalNumberOfCells in interface Rowpublic void setHeight(short height)
public void setZeroHeight(boolean zHeight)
setZeroHeight in interface RowzHeight - height is zero or not.public boolean getZeroHeight()
getZeroHeight in interface Rowpublic void setHeightInPoints(float height)
setHeightInPoints in interface Rowheight - the height in points. -1 resets to the default heightpublic short getHeight()
Sheet.getDefaultRowHeightInPoints()public float getHeightInPoints()
Sheet.getDefaultRowHeightInPoints()getHeightInPoints in interface RowSheet.getDefaultRowHeightInPoints()public boolean isFormatted()
getRowStyle()isFormatted in interface Rowpublic CellStyle getRowStyle()
isFormatted() to check first.getRowStyle in interface Rowpublic void setRowStyle(CellStyle style)
setRowStyle in interface Rowpublic Iterator<Cell> cellIterator()
cellIterator in interface RowCopyright © 2020. All rights reserved.