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 | Description |
---|---|---|
class |
HSSFRow |
High level representation of a row of a spreadsheet.
|
Modifier and Type | Method | 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 | Description |
---|---|---|
void |
HSSFSheet.removeRow(Row row) |
Remove a row from this sheet.
|
Modifier and Type | Method | 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 | Description |
---|---|---|
java.util.Iterator<Row> |
Sheet.rowIterator() |
Returns an iterator of the physical rows
|
Modifier and Type | Method | Description |
---|---|---|
void |
Sheet.removeRow(Row row) |
Remove a row from this sheet.
|
Modifier and Type | Method | 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 | 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 | Description |
---|---|---|
class |
SXSSFRow |
Streaming version of XSSFRow implementing the "BigGridDemo" strategy.
|
Modifier and Type | Method | Description |
---|---|---|
Row |
SXSSFSheet.createRow(int rownum) |
Create a new row within the sheet and return the high level representation
|
Row |
SXSSFCell.getRow() |
Returns the Row this cell belongs to
|
Row |
SXSSFSheet.getRow(int rownum) |
Returns the logical row (not physical) 0-based.
|
Modifier and Type | Method | Description |
---|---|---|
java.util.Iterator<Row> |
SXSSFSheet.iterator() |
|
java.util.Iterator<Row> |
SXSSFSheet.rowIterator() |
Returns an iterator of the physical rows
|
Modifier and Type | Method | Description |
---|---|---|
void |
SXSSFSheet.removeRow(Row row) |
Remove a row from this sheet.
|
Modifier and Type | Class | Description |
---|---|---|
class |
XSSFRow |
High level representation of a row of a spreadsheet.
|
Modifier and Type | Method | 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 | Description |
---|---|---|
void |
XSSFSheet.removeRow(Row row) |
Remove a row from this sheet.
|
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.