Package | Description |
---|---|
org.apache.poi.xssf.usermodel | |
org.apache.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,
CellType type)
Use this to create new cells within the row and return it.
|
XSSFCell |
XSSFFormulaEvaluator.evaluateInCell(Cell cell) |
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 |
---|---|
CellRange<XSSFCell> |
XSSFSheet.removeArrayFormula(Cell cell) |
CellRange<XSSFCell> |
XSSFSheet.setArrayFormula(java.lang.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)
|
protected void |
XSSFSheet.onDeleteFormula(XSSFCell cell,
BaseXSSFEvaluationWorkbook evalWb)
when a cell with a 'master' shared formula is removed, the next cell in the range becomes the master
|
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 2021 The Apache Software Foundation or its licensors, as applicable.