| 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.MissingCellPolicyfrom 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 2018 The Apache Software Foundation or its licensors, as applicable.