create_range method

create_range(self, address)

Creates a Range object from an address of the range.

Returns

A Range object


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

create_range(self, upper_left_cell, lower_right_cell)

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_cellSystem.StringUpper left cell name.
lower_right_cellSystem.StringLower right cell name.

create_range(self, first_index, number, is_vertical)

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(self, first_row, first_column, total_rows, total_columns)

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