Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.apache.poi.ss.usermodel | |
org.apache.poi.ss.usermodel.charts | |
org.apache.poi.ss.util | |
org.apache.poi.ss.util.cellwalk | |
org.apache.poi.xssf.streaming | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Class and Description |
---|---|
class |
HSSFSheet
High level representation of a worksheet.
|
Modifier and Type | Method and Description |
---|---|
int |
HSSFWorkbook.getSheetIndex(Sheet sheet)
Returns the index of the given sheet
|
Modifier and Type | Method and Description |
---|---|
Sheet |
Workbook.cloneSheet(int sheetNum)
Create an Sheet from an existing sheet in the Workbook.
|
Sheet |
Workbook.createSheet()
Sreate an Sheet for this Workbook, adds it to the sheets and returns
the high level representation.
|
Sheet |
Workbook.createSheet(java.lang.String sheetname)
Create a new sheet for this Workbook and return the high level representation.
|
Sheet |
Picture.getSheet() |
Sheet |
Row.getSheet()
Returns the Sheet this row belongs to
|
Sheet |
Cell.getSheet()
Returns the sheet this cell belongs to
|
Sheet |
Workbook.getSheet(java.lang.String name)
Get sheet with the given name
|
Sheet |
Workbook.getSheetAt(int index)
Get the Sheet object at the given index.
|
Modifier and Type | Method and Description |
---|---|
int |
Workbook.getSheetIndex(Sheet sheet)
Returns the index of the given sheet
|
Modifier and Type | Method and Description |
---|---|
static ChartDataSource<java.lang.Number> |
DataSources.fromNumericCellRange(Sheet sheet,
CellRangeAddress cellRangeAddress) |
static ChartDataSource<java.lang.String> |
DataSources.fromStringCellRange(Sheet sheet,
CellRangeAddress cellRangeAddress) |
Modifier and Type | Method and Description |
---|---|
Sheet |
SheetBuilder.build()
Builds sheet from parent workbook and 2D array with cell
values.
|
Modifier and Type | Method and Description |
---|---|
static Cell |
SheetUtil.getCellWithMerges(Sheet sheet,
int rowIx,
int colIx)
Return the cell, taking account of merged regions.
|
static double |
SheetUtil.getColumnWidth(Sheet sheet,
int column,
boolean useMergedCells)
Compute width of a column and return the result
|
static double |
SheetUtil.getColumnWidth(Sheet sheet,
int column,
boolean useMergedCells,
int firstRow,
int lastRow)
Compute width of a column based on a subset of the rows and return the result
|
static Row |
CellUtil.getRow(int rowIndex,
Sheet sheet)
Get a row from the spreadsheet, and create it if it doesn't exist.
|
static void |
RegionUtil.setBorderBottom(int border,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the borderBottom attribute of the RegionUtil object
|
static void |
RegionUtil.setBorderLeft(int border,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the left border for a region of cells by manipulating the cell style of the individual
cells on the left
|
static void |
RegionUtil.setBorderRight(int border,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the borderRight attribute of the RegionUtil object
|
static void |
RegionUtil.setBorderTop(int border,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the borderBottom attribute of the RegionUtil object
|
static void |
RegionUtil.setBottomBorderColor(int color,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the bottomBorderColor attribute of the RegionUtil object
|
static void |
RegionUtil.setLeftBorderColor(int color,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the leftBorderColor attribute of the RegionUtil object
|
static void |
RegionUtil.setRightBorderColor(int color,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the rightBorderColor attribute of the RegionUtil object
|
static void |
RegionUtil.setTopBorderColor(int color,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the topBorderColor attribute of the RegionUtil object
|
Constructor and Description |
---|
CellWalk(Sheet sheet,
CellRangeAddress range) |
Modifier and Type | Class and Description |
---|---|
class |
SXSSFSheet
Streaming version of XSSFSheet implementing the "BigGridDemo" strategy.
|
Modifier and Type | Method and Description |
---|---|
Sheet |
SXSSFWorkbook.cloneSheet(int sheetNum)
Create an Sheet from an existing sheet in the Workbook.
|
Sheet |
SXSSFWorkbook.createSheet()
Sreate an Sheet for this Workbook, adds it to the sheets and returns
the high level representation.
|
Sheet |
SXSSFWorkbook.createSheet(java.lang.String sheetname)
Create an Sheet for this Workbook, adds it to the sheets and returns
the high level representation.
|
Sheet |
SXSSFRow.getSheet()
Returns the Sheet this row belongs to
|
Sheet |
SXSSFCell.getSheet()
Returns the sheet this cell belongs to
|
Sheet |
SXSSFWorkbook.getSheet(java.lang.String name)
Get sheet with the given name
|
Sheet |
SXSSFWorkbook.getSheetAt(int index)
Get the Sheet object at the given index.
|
Modifier and Type | Method and Description |
---|---|
int |
SXSSFWorkbook.getSheetIndex(Sheet sheet)
Returns the index of the given sheet
|
Modifier and Type | Class and Description |
---|---|
class |
XSSFChartSheet
High level representation of Sheet Parts that are of type 'chartsheet'.
|
class |
XSSFDialogsheet |
class |
XSSFSheet
High level representation of a SpreadsheetML worksheet.
|
Modifier and Type | Method and Description |
---|---|
Sheet |
XSSFPivotTable.getDataSheet() |
Sheet |
XSSFPivotTable.getParentSheet() |
Modifier and Type | Method and Description |
---|---|
protected void |
XSSFPivotCacheDefinition.createCacheFields(Sheet sheet)
Generates a cache field for each column in the reference area for the pivot table.
|
XSSFPivotTable |
XSSFSheet.createPivotTable(AreaReference source,
CellReference position,
Sheet sourceSheet)
Create a pivot table and set area of source, source sheet and a position for pivot table
|
protected void |
XSSFPivotTable.createSourceReferences(AreaReference source,
CellReference position,
Sheet sourceSheet)
Creates cacheSource and workSheetSource for pivot table and sets the source reference as well assets the location of the pivot table
|
int |
XSSFWorkbook.getSheetIndex(Sheet sheet)
Returns the index of the given sheet
|
Copyright 2015 The Apache Software Foundation or its licensors, as applicable.