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.util | |
org.apache.poi.xssf.streaming | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Class and Description |
---|---|
class |
HSSFRow
High level representation of a row of a spreadsheet.
|
Modifier and Type | Method and Description |
---|---|
java.util.Iterator<Row> |
HSSFSheet.iterator()
Alias for
HSSFSheet.rowIterator() to allow
foreach loops |
java.util.Iterator<Row> |
HSSFSheet.rowIterator() |
Modifier and Type | Method and Description |
---|---|
void |
HSSFSheet.removeRow(Row row)
Remove a row from this sheet.
|
Modifier and Type | Method and Description |
---|---|
Row |
Sheet.createRow(int rownum)
Create a new row within the sheet and return the high level representation
|
Row |
Cell.getRow()
Returns the Row this cell belongs to
|
Row |
Sheet.getRow(int rownum)
Returns the logical row (not physical) 0-based.
|
Modifier and Type | Method and Description |
---|---|
java.util.Iterator<Row> |
Sheet.rowIterator()
Returns an iterator of the physical rows
|
Modifier and Type | Method and Description |
---|---|
void |
Sheet.removeRow(Row row)
Remove a row from this sheet.
|
Modifier and Type | Method and Description |
---|---|
static Row |
CellUtil.getRow(int rowIndex,
Sheet sheet)
Get a row from the spreadsheet, and create it if it doesn't exist.
|
Modifier and Type | Method and Description |
---|---|
static Cell |
CellUtil.createCell(Row row,
int column,
java.lang.String value)
Create a cell, and give it a value.
|
static Cell |
CellUtil.createCell(Row row,
int column,
java.lang.String value,
CellStyle style)
Creates a cell, gives it a value, and applies a style if provided
|
static Cell |
CellUtil.getCell(Row row,
int columnIndex)
Get a specific cell from a row.
|
Modifier and Type | Class and Description |
---|---|
class |
SXSSFRow
Streaming version of XSSFRow implementing the "BigGridDemo" strategy.
|
Modifier and Type | Method and Description |
---|---|
Row |
SXSSFCell.getRow()
Returns the Row this cell belongs to
|
Modifier and Type | Method and Description |
---|---|
java.util.Iterator<Row> |
SXSSFSheet.iterator() |
java.util.Iterator<Row> |
SXSSFSheet.rowIterator()
Returns an iterator of the physical rows
|
Modifier and Type | Method and Description |
---|---|
void |
SXSSFSheet.removeRow(Row row)
Remove a row from this sheet.
|
Modifier and Type | Class and Description |
---|---|
class |
XSSFRow
High level representation of a row of a spreadsheet.
|
Modifier and Type | Method and Description |
---|---|
java.util.Iterator<Row> |
XSSFSheet.iterator()
Alias for
XSSFSheet.rowIterator() to
allow foreach loops |
java.util.Iterator<Row> |
XSSFSheet.rowIterator() |
Modifier and Type | Method and Description |
---|---|
void |
XSSFRow.copyRowFrom(Row srcRow,
CellCopyPolicy policy)
Copy the cells from srcRow to this row
If this row is not a blank row, this will merge the two rows, overwriting
the cells in this row with the cells in srcRow
If srcRow is null, overwrite cells in destination row with blank values, styles, etc per cell copy policy
srcRow may be from a different sheet in the same workbook
|
void |
XSSFSheet.removeRow(Row row)
Remove a row from this sheet.
|
Modifier and Type | Method and Description |
---|---|
void |
XSSFSheet.copyRows(java.util.List<? extends Row> srcRows,
int destStartRow,
CellCopyPolicy policy)
copyRows rows from srcRows to this sheet starting at destStartRow
Additionally copies merged regions that are completely defined in these
rows (ie.
|
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.