Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.apache.poi.ss.usermodel | |
org.apache.poi.xssf.streaming | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Method | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 2018 The Apache Software Foundation or its licensors, as applicable.