insert_range method

insert_range

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

def insert_range(self, area, shift_type):
    ...
ParameterTypeDescription
areaCellAreaShift area.
shift_typeShiftTypeShift cells option.

insert_range

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

def insert_range(self, area, shift_number, shift_type):
    ...
ParameterTypeDescription
areaCellAreaShift area.
shift_numberintNumber of rows or columns to be inserted.
shift_typeShiftTypeShift cells option.

insert_range

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
areaCellAreaShift area.
shift_numberintNumber of rows or columns to be inserted.
shift_typeShiftTypeShift cells option.
update_referenceboolIndicates whether update references in other worksheets.

See Also