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.usermodel |
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.
|
Modifier and Type | Method and Description |
---|---|
CellCopyPolicy |
CellCopyPolicy.Builder.build() |
Constructor and Description |
---|
CellCopyPolicy(CellCopyPolicy other)
Copy constructor
|
Modifier and Type | Method and Description |
---|---|
static void |
CellUtil.copyCell(Cell srcCell,
Cell destCell,
CellCopyPolicy policy,
CellCopyContext context)
Copy cell value, formula and style, from srcCell per cell copy policy
If srcCell is null, clears the cell value and cell style per cell copy policy.
|
Modifier and Type | Method and Description |
---|---|
void |
XSSFCell.copyCellFrom(Cell srcCell,
CellCopyPolicy policy)
Copy cell value, formula and style, from srcCell per cell copy policy
If srcCell is null, clears the cell value and cell style per cell copy policy
This does not shift references in formulas.
|
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.copyRows(int srcStartRow,
int srcEndRow,
int destStartRow,
CellCopyPolicy cellCopyPolicy)
Copies rows between srcStartRow and srcEndRow to the same sheet, starting at destStartRow
Convenience function for
XSSFSheet.copyRows(List, int, CellCopyPolicy)
Equivalent to copyRows(getRows(srcStartRow, srcEndRow, false), destStartRow, cellCopyPolicy) |
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.