Package | Description |
---|---|
org.zkoss.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.zkoss.poi.ss.usermodel | |
org.zkoss.poi.xssf.streaming | |
org.zkoss.poi.xssf.usermodel |
Modifier and Type | Method and Description |
---|---|
Row.MissingCellPolicy |
HSSFWorkbook.getMissingCellPolicy()
Retrieves the current policy on what to do when
getting missing or blank cells from a row.
|
Modifier and Type | Method and Description |
---|---|
HSSFCell |
HSSFRow.getCell(int cellnum,
Row.MissingCellPolicy policy)
Get the hssfcell representing a given column (logical cell)
0-based.
|
void |
HSSFWorkbook.setMissingCellPolicy(Row.MissingCellPolicy missingCellPolicy)
Sets the policy on what to do when
getting missing or blank cells from a row.
|
Modifier and Type | Field and Description |
---|---|
static Row.MissingCellPolicy |
Row.CREATE_NULL_AS_BLANK
A new, blank cell is created for missing cells.
|
static Row.MissingCellPolicy |
Row.RETURN_BLANK_AS_NULL
Missing cells are returned as null, as are blank cells
|
static Row.MissingCellPolicy |
Row.RETURN_NULL_AND_BLANK
Missing cells are returned as null, Blank cells are returned as normal
|
Modifier and Type | Method and Description |
---|---|
Row.MissingCellPolicy |
Workbook.getMissingCellPolicy()
Retrieves the current policy on what to do when
getting missing or blank cells from a row.
|
Modifier and Type | Method and Description |
---|---|
Cell |
Row.getCell(int cellnum,
Row.MissingCellPolicy policy)
Returns the cell at the given (0 based) index, with the specified
Row.MissingCellPolicy |
void |
Workbook.setMissingCellPolicy(Row.MissingCellPolicy missingCellPolicy)
Sets the policy on what to do when
getting missing or blank cells from a row.
|
Modifier and Type | Method and Description |
---|---|
Row.MissingCellPolicy |
SXSSFWorkbook.getMissingCellPolicy()
Retrieves the current policy on what to do when
getting missing or blank cells from a row.
|
Modifier and Type | Method and Description |
---|---|
Cell |
SXSSFRow.getCell(int cellnum,
Row.MissingCellPolicy policy)
Returns the cell at the given (0 based) index, with the specified
Row.MissingCellPolicy |
void |
SXSSFWorkbook.setMissingCellPolicy(Row.MissingCellPolicy missingCellPolicy)
Sets the policy on what to do when
getting missing or blank cells from a row.
|
Modifier and Type | Method and Description |
---|---|
Row.MissingCellPolicy |
XSSFWorkbook.getMissingCellPolicy()
Retrieves the current policy on what to do when
getting missing or blank cells from a row.
|
Modifier and Type | Method and Description |
---|---|
XSSFCell |
XSSFRow.getCell(int cellnum,
Row.MissingCellPolicy policy)
Returns the cell at the given (0 based) index, with the specified
Row.MissingCellPolicy |
void |
XSSFWorkbook.setMissingCellPolicy(Row.MissingCellPolicy missingCellPolicy)
Sets the policy on what to do when
getting missing or blank cells from a row.
|
Copyright © 2020. All rights reserved.