| Package | Description | 
|---|---|
| org.apache.poi.xddf.usermodel.chart | |
| org.apache.poi.xssf.model | |
| org.apache.poi.xssf.streaming | |
| org.apache.poi.xssf.usermodel | |
| org.apache.poi.xssf.usermodel.helpers | 
| Modifier and Type | Method and Description | 
|---|---|
protected void | 
XDDFChart.fillSheet(XSSFSheet sheet,
         XDDFDataSource<?> categoryData,
         XDDFNumericalDataSource<?> valuesData)
this method writes the data into sheet 
 | 
static XDDFNumericalDataSource<java.lang.Double> | 
XDDFDataSourcesFactory.fromNumericCellRange(XSSFSheet sheet,
                    CellRangeAddress cellRangeAddress)  | 
static XDDFCategoryDataSource | 
XDDFDataSourcesFactory.fromStringCellRange(XSSFSheet sheet,
                   CellRangeAddress cellRangeAddress)  | 
| Modifier and Type | Method and Description | 
|---|---|
XSSFSheet | 
SingleXmlCells.getXSSFSheet()  | 
| Modifier and Type | Method and Description | 
|---|---|
XSSFSheet | 
SXSSFPicture.getSheet()  | 
protected XSSFSheet | 
SXSSFWorkbook.getSheetFromZipEntryName(java.lang.String sheetRef)  | 
XSSFSheet | 
DeferredSXSSFWorkbook.getXSSFSheet(java.lang.String name)  | 
| Constructor and Description | 
|---|
DeferredSXSSFSheet(DeferredSXSSFWorkbook workbook,
                  XSSFSheet xSheet)  | 
SXSSFSheet(SXSSFWorkbook workbook,
          XSSFSheet xSheet)  | 
SXSSFSheet(SXSSFWorkbook workbook,
          XSSFSheet xSheet,
          int randomAccessWindowSize)  | 
| Modifier and Type | Class and Description | 
|---|---|
class  | 
XSSFChartSheet
High level representation of Sheet Parts that are of type 'chartsheet'. 
 | 
class  | 
XSSFDialogsheet  | 
| Modifier and Type | Method and Description | 
|---|---|
XSSFSheet | 
XSSFWorkbook.cloneSheet(int sheetNum)
Create an XSSFSheet from an existing sheet in the XSSFWorkbook. 
 | 
XSSFSheet | 
XSSFWorkbook.cloneSheet(int sheetNum,
          java.lang.String newName)
Create an XSSFSheet from an existing sheet in the XSSFWorkbook. 
 | 
XSSFSheet | 
XSSFWorkbook.createSheet()
Create an XSSFSheet for this workbook, adds it to the sheets and returns
 the high level representation. 
 | 
XSSFSheet | 
XSSFWorkbook.createSheet(java.lang.String sheetname)
Create a new sheet for this Workbook and return the high level representation. 
 | 
XSSFSheet | 
XSSFPicture.getSheet()  | 
XSSFSheet | 
XSSFCell.getSheet()
Returns the sheet this cell belongs to 
 | 
protected XSSFSheet | 
XSSFObjectData.getSheet()  | 
XSSFSheet | 
XSSFDrawing.getSheet()  | 
XSSFSheet | 
XSSFRow.getSheet()
Returns the XSSFSheet this row belongs to 
 | 
XSSFSheet | 
XSSFWorkbook.getSheet(java.lang.String name)
Get sheet with the given name (case insensitive match) 
 | 
XSSFSheet | 
XSSFWorkbook.getSheetAt(int index)
Get the XSSFSheet object at the given index. 
 | 
XSSFSheet | 
XSSFTable.getXSSFSheet()  | 
| Modifier and Type | Method and Description | 
|---|---|
void | 
XSSFSignatureLine.add(XSSFSheet sheet,
   XSSFClientAnchor anchor)  | 
void | 
XSSFSignatureLine.parse(XSSFSheet sheet)  | 
void | 
XSSFPivotTable.setParentSheet(XSSFSheet parentSheet)  | 
| Modifier and Type | Method and Description | 
|---|---|
void | 
XSSFWorkbook.parseSheet(java.util.Map<java.lang.String,XSSFSheet> shIdMap,
          org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet ctSheet)
Not normally to be called externally, but possibly to be overridden to avoid
 the DOM based parse of large sheets (see examples). 
 | 
| Constructor and Description | 
|---|
XSSFClientAnchor(XSSFSheet sheet,
                org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTMarker cell1,
                org.openxmlformats.schemas.drawingml.x2006.main.CTPositiveSize2D size)
Create XSSFClientAnchor from existing xml beans, sized and positioned relative to a pair of cells. 
 | 
XSSFClientAnchor(XSSFSheet sheet,
                org.openxmlformats.schemas.drawingml.x2006.main.CTPoint2D position,
                org.openxmlformats.schemas.drawingml.x2006.main.CTPositiveSize2D size)
Create XSSFClientAnchor from existing xml beans, sized and positioned relative to a pair of cells. 
 | 
XSSFDataValidationHelper(XSSFSheet xssfSheet)  | 
XSSFDialogsheet(XSSFSheet sheet)  | 
XSSFRow(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRow row,
       XSSFSheet sheet)
Construct a XSSFRow. 
 | 
| Constructor and Description | 
|---|
XSSFColumnShifter(XSSFSheet sh)  | 
XSSFRowShifter(XSSFSheet sh)  | 
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.