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) |
void |
XDDFChart.replaceReferences(XSSFSheet newSheet)
Replace references to the sheet name in the data supporting the chart.
|
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 |
XSSFRow.getSheet()
Returns the XSSFSheet this row belongs to
|
XSSFSheet |
XSSFCell.getSheet()
Returns the sheet this cell belongs to
|
XSSFSheet |
XSSFDrawing.getSheet() |
protected XSSFSheet |
XSSFObjectData.getSheet() |
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 2022 The Apache Software Foundation or its licensors, as applicable.