Class ColumnShifter
- java.lang.Object
-
- org.apache.poi.ss.usermodel.helpers.BaseRowColShifter
-
- org.apache.poi.ss.usermodel.helpers.ColumnShifter
-
- Direct Known Subclasses:
HSSFColumnShifter
,XSSFColumnShifter
@Beta public abstract class ColumnShifter extends BaseRowColShifter
Helper for shifting columns up or down- Since:
- POI 4.0.0
-
-
Constructor Summary
Constructors Constructor Description ColumnShifter(Sheet sh)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
shiftColumns(int firstShiftColumnIndex, int lastShiftColumnIndex, int step)
java.util.List<CellRangeAddress>
shiftMergedRegions(int startColumn, int endColumn, int n)
Shifts, grows, or shrinks the merged regions due to a column shift.-
Methods inherited from class org.apache.poi.ss.usermodel.helpers.BaseRowColShifter
shiftRange, updateConditionalFormatting, updateFormulas, updateHyperlinks, updateNamedRanges
-
-
-
-
Constructor Detail
-
ColumnShifter
public ColumnShifter(Sheet sh)
-
-
Method Detail
-
shiftMergedRegions
public java.util.List<CellRangeAddress> shiftMergedRegions(int startColumn, int endColumn, int n)
Shifts, grows, or shrinks the merged regions due to a column shift. Merged regions that are completely overlaid by shifting will be deleted.- Specified by:
shiftMergedRegions
in classBaseRowColShifter
- Parameters:
startColumn
- the column to start shiftingendColumn
- the column to end shiftingn
- the number of columns to shift- Returns:
- an array of affected merged regions, doesn't contain deleted ones
- Since:
- POI 4.0.0
-
shiftColumns
public void shiftColumns(int firstShiftColumnIndex, int lastShiftColumnIndex, int step)
-
-