Package | Description |
---|---|
org.apache.poi.xssf.usermodel | |
org.apache.poi.xssf.usermodel.helpers |
Modifier and Type | Method | 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 | Description |
---|---|---|
CellRange<XSSFCell> |
XSSFSheet.removeArrayFormula(Cell cell) |
|
CellRange<XSSFCell> |
XSSFSheet.setArrayFormula(java.lang.String formula,
CellRangeAddress range) |
Modifier and Type | Method | 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 | Description |
---|---|---|
XSSFCell |
XSSFSingleXmlCell.getReferencedCell() |
Gets the XSSFCell referenced by the R attribute or creates a new one if cell doesn't exists
|
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.