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.usermodel.helpers | |
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 |
---|---|
java.util.Iterator<Sheet> |
HSSFWorkbook.iterator()
Alias for
HSSFWorkbook.sheetIterator() to allow
foreach loops |
java.util.Iterator<Sheet> |
HSSFWorkbook.sheetIterator()
Returns an iterator of the sheets in the workbook
in sheet order.
|
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 |
Cell.getSheet()
Returns the sheet this cell belongs to
|
Sheet |
Picture.getSheet() |
Sheet |
Row.getSheet()
Returns the Sheet this row 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 |
---|---|
java.util.Iterator<Sheet> |
Workbook.sheetIterator()
Returns an iterator of the sheets in the workbook
in sheet order.
|
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 | Field and Description |
---|---|
protected Sheet |
RowShifter.sheet |
Constructor and Description |
---|
RowShifter(Sheet sh) |
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)
Sets the bottom border for a region of cells by manipulating the cell style of the individual
cells on the bottom
|
static void |
RegionUtil.setBorderBottom(int border,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Deprecated.
3.15 beta 2. Use
RegionUtil.setBorderBottom(int, CellRangeAddress, Sheet) . |
static void |
RegionUtil.setBorderLeft(int border,
CellRangeAddress region,
Sheet sheet)
Sets the left border for a region of cells by manipulating the cell style of the individual
cells on the left
|
static void |
RegionUtil.setBorderLeft(int border,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Deprecated.
3.15 beta 2. Use
RegionUtil.setBorderLeft(int, CellRangeAddress, Sheet) . |
static void |
RegionUtil.setBorderRight(int border,
CellRangeAddress region,
Sheet sheet)
Sets the right border for a region of cells by manipulating the cell style of the individual
cells on the right
|
static void |
RegionUtil.setBorderRight(int border,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Deprecated.
3.15 beta 2. Use
RegionUtil.setBorderRight(int, CellRangeAddress, Sheet) . |
static void |
RegionUtil.setBorderTop(int border,
CellRangeAddress region,
Sheet sheet)
Sets the top border for a region of cells by manipulating the cell style of the individual
cells on the top
|
static void |
RegionUtil.setBorderTop(int border,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Deprecated.
3.15 beta 2. Use
RegionUtil.setBorderTop(int, CellRangeAddress, Sheet) . |
static void |
RegionUtil.setBottomBorderColor(int color,
CellRangeAddress region,
Sheet sheet)
Sets the bottom border color for a region of cells by manipulating the cell style of the individual
cells on the bottom
|
static void |
RegionUtil.setBottomBorderColor(int color,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Deprecated.
3.15 beta 2. Use
RegionUtil.setBottomBorderColor(int, CellRangeAddress, Sheet) . |
static void |
RegionUtil.setLeftBorderColor(int color,
CellRangeAddress region,
Sheet sheet)
Sets the left border color for a region of cells by manipulating the cell style of the individual
cells on the left
|
static void |
RegionUtil.setLeftBorderColor(int color,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Deprecated.
3.15 beta 2. Use
RegionUtil.setLeftBorderColor(int, CellRangeAddress, Sheet) . |
static void |
RegionUtil.setRightBorderColor(int color,
CellRangeAddress region,
Sheet sheet)
Sets the right border color for a region of cells by manipulating the cell style of the individual
cells on the right
|
static void |
RegionUtil.setRightBorderColor(int color,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Deprecated.
3.15 beta 2. Use
RegionUtil.setRightBorderColor(int, CellRangeAddress, Sheet) . |
static void |
RegionUtil.setTopBorderColor(int color,
CellRangeAddress region,
Sheet sheet)
Sets the top border color for a region of cells by manipulating the cell style of the individual
cells on the top
|
static void |
RegionUtil.setTopBorderColor(int color,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Deprecated.
3.15 beta 2. Use
RegionUtil.setTopBorderColor(int, CellRangeAddress, Sheet) . |
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)
Not implemented for SXSSFWorkbook
Create an Sheet from an existing sheet in the Workbook.
|
Modifier and Type | Method and Description |
---|---|
java.util.Iterator<Sheet> |
SXSSFWorkbook.iterator()
Alias for
SXSSFWorkbook.sheetIterator() to allow
foreach loops |
java.util.Iterator<Sheet> |
SXSSFWorkbook.sheetIterator()
Returns an iterator of the sheets in the workbook
in sheet order.
|
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 |
---|---|
java.util.Iterator<Sheet> |
XSSFWorkbook.iterator()
Alias for
XSSFWorkbook.sheetIterator() to allow
foreach loops
Iterator |
java.util.Iterator<Sheet> |
XSSFWorkbook.sheetIterator()
Returns an iterator of the sheets in the workbook
in sheet order.
|
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 2017 The Apache Software Foundation or its licensors, as applicable.