Package | Description |
---|---|
org.apache.poi.ss.usermodel | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Method and Description |
---|---|
CellCopyPolicy |
CellCopyPolicy.Builder.build() |
Constructor and Description |
---|
CellCopyPolicy(CellCopyPolicy other)
Copy constructor
|
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
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.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 2021 The Apache Software Foundation or its licensors, as applicable.