|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface Row
High level representation of a row of a spreadsheet.
Nested Class Summary | |
---|---|
static class |
Row.MissingCellPolicy
Used to specify the different possible policies if for the case of null and blank cells |
Field Summary | |
---|---|
static Row.MissingCellPolicy |
CREATE_NULL_AS_BLANK
A new, blank cell is created for missing cells. |
static Row.MissingCellPolicy |
RETURN_BLANK_AS_NULL
Missing cells are returned as null, as are blank cells |
static Row.MissingCellPolicy |
RETURN_NULL_AND_BLANK
Missing cells are returned as null, Blank cells are returned as normal |
Method Summary | |
---|---|
java.util.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 |
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. |
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 styles. |
Sheet |
getSheet()
Returns the Sheet this row belongs to |
boolean |
getZeroHeight()
Get whether or not to display this row with 0 height |
boolean |
isFormatted()
Is this row formatted? Most aren't, but some rows do have whole-row styles. |
void |
removeCell(Cell cell)
Remove the Cell from this row. |
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 |
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 |
Methods inherited from interface java.lang.Iterable |
---|
iterator |
Field Detail |
---|
static final Row.MissingCellPolicy RETURN_NULL_AND_BLANK
static final Row.MissingCellPolicy RETURN_BLANK_AS_NULL
static final Row.MissingCellPolicy CREATE_NULL_AS_BLANK
Method Detail |
---|
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
.
column
- - the column number this cell represents
java.lang.IllegalArgumentException
- if columnIndex < 0 or greater than the maximum number of supported columns
(255 for *.xls, 1048576 for *.xlsx)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.
column
- - the column number this cell represents
java.lang.IllegalArgumentException
- if columnIndex < 0 or greate than a maximum number of supported columns
(255 for *.xls, 1048576 for *.xlsx)void removeCell(Cell cell)
cell
- the cell to removevoid setRowNum(int rowNum)
rowNum
- the row number (0-based)
java.lang.IllegalArgumentException
- if rowNum < 0int getRowNum()
Cell getCell(int cellnum)
cellnum
- 0 based column number
getCell(int, org.apache.poi.ss.usermodel.Row.MissingCellPolicy)
Cell getCell(int cellnum, Row.MissingCellPolicy policy)
Row.MissingCellPolicy
java.lang.IllegalArgumentException
- if cellnum < 0 or the specified MissingCellPolicy is invalidRETURN_NULL_AND_BLANK
,
RETURN_BLANK_AS_NULL
,
CREATE_NULL_AS_BLANK
short getFirstCellNum()
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 }
int getPhysicalNumberOfCells()
void setHeight(short height)
height
- rowheight or 0xff for undefined (use sheet default)void setZeroHeight(boolean zHeight)
zHeight
- height is zero or not.boolean getZeroHeight()
void setHeightInPoints(float height)
height
- the height in points. -1
resets to the default heightshort getHeight()
Sheet.getDefaultRowHeightInPoints()
float getHeightInPoints()
Sheet.getDefaultRowHeightInPoints()
Sheet.getDefaultRowHeightInPoints()
boolean isFormatted()
getRowStyle()
CellStyle getRowStyle()
isFormatted()
to check first.
void setRowStyle(CellStyle style)
java.util.Iterator<Cell> cellIterator()
Sheet getSheet()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |