insert_range method

insert_range(self, area, shift_type)

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


def insert_range(self, area, shift_type):
    ...
ParameterTypeDescription
areaaspose.cells.CellAreaShift area.
shift_typeaspose.cells.ShiftTypeShift cells option.

insert_range(self, area, shift_number, shift_type)

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


def insert_range(self, area, shift_number, shift_type):
    ...
ParameterTypeDescription
areaaspose.cells.CellAreaShift area.
shift_numberintNumber of rows or columns to be inserted.
shift_typeaspose.cells.ShiftTypeShift cells option.

insert_range(self, area, shift_number, shift_type, update_reference)

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


def insert_range(self, area, shift_number, shift_type, update_reference):
    ...
ParameterTypeDescription
areaaspose.cells.CellAreaShift area.
shift_numberintNumber of rows or columns to be inserted.
shift_typeaspose.cells.ShiftTypeShift cells option.
update_referenceboolIndicates whether update references in other worksheets.

See Also