| Package | Description |
|---|---|
| org.apache.poi.hssf.usermodel |
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
|
| org.apache.poi.ss.usermodel | |
| org.apache.poi.ss.util |
| Modifier and Type | Class and Description |
|---|---|
class |
HSSFRow
High level representation of a row of a spreadsheet.
|
| Modifier and Type | Method and Description |
|---|---|
Iterator<Row> |
HSSFSheet.rowIterator() |
Spliterator<Row> |
HSSFSheet.spliterator() |
| Modifier and Type | Method and Description |
|---|---|
void |
HSSFRow.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 |
HSSFRow.copyRowFrom(Row srcRow,
CellCopyPolicy policy,
CellCopyContext context)
Copy the cells from srcRow to this row.
|
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 |
|---|---|
default Iterator<Row> |
Sheet.iterator()
Alias for
Sheet.rowIterator() to allow foreach loops |
Iterator<Row> |
Sheet.rowIterator()
Returns an iterator of the physical rows
|
default Spliterator<Row> |
Sheet.spliterator()
Returns a spliterator 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,
String value)
Create a cell, and give it a value.
|
static Cell |
CellUtil.createCell(Row row,
int column,
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.
|