Cells.InsertRange

InsertRange(CellArea, int, ShiftType, bool)

Inserts a range of cells and shift cells according to the shift option.

public void InsertRange(CellArea area, int shiftNumber, ShiftType shiftType, bool updateReference)
ParameterTypeDescription
areaCellAreaShift area.
shiftNumberInt32Number of rows or columns to be inserted.
shiftTypeShiftTypeShift cells option.
updateReferenceBooleanIndicates whether update references in other worksheets.

See Also


InsertRange(CellArea, ShiftType)

Inserts a range of cells and shift cells according to the shift option.

public void InsertRange(CellArea area, ShiftType shiftType)
ParameterTypeDescription
areaCellAreaShift area.
shiftTypeShiftTypeShift cells option.

See Also


InsertRange(CellArea, int, ShiftType)

Inserts a range of cells and shift cells according to the shift option.

public void InsertRange(CellArea area, int shiftNumber, ShiftType shiftType)
ParameterTypeDescription
areaCellAreaShift area.
shiftNumberInt32Number of rows or columns to be inserted.
shiftTypeShiftTypeShift cells option.

See Also