org.apache.poi.xssf.usermodel.helpers
Class XSSFRowShifter
java.lang.Object
org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter
public final class XSSFRowShifter
- extends java.lang.Object
- Author:
- Yegor Kozlov
Method Summary |
java.util.List |
shiftMerged(int startRow,
int endRow,
int n)
Shift merged regions |
void |
updateFormulas(org.apache.poi.hssf.record.formula.FormulaShifter shifter)
Update formulas. |
void |
updateNamedRanges(org.apache.poi.hssf.record.formula.FormulaShifter shifter)
Updated named ranges |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
XSSFRowShifter
public XSSFRowShifter(XSSFSheet sh)
shiftMerged
public java.util.List shiftMerged(int startRow,
int endRow,
int n)
- Shift merged regions
- Parameters:
startRow
- the row to start shiftingendRow
- the row to end shiftingn
- the number of rows to shift
- Returns:
- an array of affected cell regions
updateNamedRanges
public void updateNamedRanges(org.apache.poi.hssf.record.formula.FormulaShifter shifter)
- Updated named ranges
updateFormulas
public void updateFormulas(org.apache.poi.hssf.record.formula.FormulaShifter shifter)
- Update formulas.