create_range method

create_range

Creates a Range object from an address of the range.

Returns

A Range object

def create_range(self, address):
    ...
ParameterTypeDescription
addressstrThe address of the range.

create_range

Creates a Range object from a range of cells.

Returns

A Range object

def create_range(self, upper_left_cell, lower_right_cell):
    ...
ParameterTypeDescription
upper_left_cellstrUpper left cell name.
lower_right_cellstrLower right cell name.

create_range

Creates a Range object from rows of cells or columns of cells.

Returns

A Range object.

def create_range(self, first_index, number, is_vertical):
    ...
ParameterTypeDescription
first_indexintFirst row index or first column index, zero based.
numberintTotal number of rows or columns, one based.
is_verticalboolTrue - Range created from columns of cells. False - Range created from rows of cells.

create_range

Creates a Range object from a range of cells.

Returns

A Range object

def create_range(self, first_row, first_column, total_rows, total_columns):
    ...
ParameterTypeDescription
first_rowintFirst row of this range
first_columnintFirst column of this range
total_rowsintNumber of rows
total_columnsintNumber of columns

See Also