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
  • Field Details

    • sheet

      protected final Sheet sheet
  • Constructor Details

    • ColumnShifter

      public ColumnShifter(Sheet sh)
  • Method Details

    • shiftMergedRegions

      public 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 class BaseRowColShifter
      Parameters:
      startColumn - the column to start shifting
      endColumn - the column to end shifting
      n - 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)