Package | Description |
---|---|
org.zkoss.poi.xssf.usermodel | |
org.zkoss.poi.xssf.usermodel.helpers |
Modifier and Type | Method and Description |
---|---|
XSSFCell |
XSSFRow.createCell(int columnIndex)
Use this to create new cells within the row and return it.
|
XSSFCell |
XSSFRow.createCell(int columnIndex,
int type)
Use this to create new cells within the row and return it.
|
XSSFCell |
XSSFFormulaEvaluator.evaluateInCell(Cell cell)
If cell contains formula, it evaluates the formula, and
puts the formula result back into the cell, in place
of the old formula.
|
XSSFCell |
XSSFRow.getCell(int cellnum)
Returns the cell at the given (0 based) index,
with the
Row.MissingCellPolicy from the parent Workbook. |
XSSFCell |
XSSFRow.getCell(int cellnum,
Row.MissingCellPolicy policy)
Returns the cell at the given (0 based) index, with the specified
Row.MissingCellPolicy |
Modifier and Type | Method and Description |
---|---|
TreeMap<Integer,XSSFCell> |
XSSFRow.getCells() |
CellRange<XSSFCell> |
XSSFSheet.removeArrayFormula(Cell cell) |
CellRange<XSSFCell> |
XSSFSheet.setArrayFormula(String formula,
CellRangeAddress range) |
Modifier and Type | Method and Description |
---|---|
protected void |
XSSFWorkbook.onDeleteFormula(XSSFCell cell)
Fired when a formula is deleted from this workbook,
for example when calling cell.setCellFormula(null)
|
Modifier and Type | Method and Description |
---|---|
XSSFCell |
XSSFSingleXmlCell.getReferencedCell()
Gets the XSSFCell referenced by the R attribute or creates a new one if cell doesn't exists
|
Copyright © 2020. All rights reserved.