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 | |
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.rowIterator() |
java.util.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 java.util.Iterator<Row> |
Sheet.iterator()
Alias for
Sheet.rowIterator() to allow foreach loops |
java.util.Iterator<Row> |
Sheet.rowIterator()
Returns an iterator of the physical rows
|
default java.util.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,
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.rowIterator()
Returns an iterator of the physical rows
|
java.util.Spliterator<Row> |
SXSSFSheet.spliterator()
Returns a spliterator 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.rowIterator() |
java.util.Spliterator<Row> |
XSSFSheet.spliterator() |
Modifier and Type | Method and Description |
---|---|
void |
XSSFRow.copyRowFrom(Row srcRow,
CellCopyPolicy policy)
Copy the cells from srcRow to this row.
|
void |
XSSFRow.copyRowFrom(Row srcRow,
CellCopyPolicy policy,
CellCopyContext context)
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
Note that if you are copying from a non-XSSF row then you will need to disable style copying
in the
CellCopyPolicy (XSSF styles are not compatible with HSSF styles, for instance). |
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 2022 The Apache Software Foundation or its licensors, as applicable.