UnionRange class

UnionRange class

Represents union range.

The UnionRange type exposes the following members:

Properties

PropertyDescription
first_rowGets the index of the first row of the range.
first_columnGets the index of the first column of the range.
row_countGets the count of rows in the range.
column_countGets the count of rows in the range.
valueGets and sets the values of the range.
nameGets or sets the name of the range.
refers_toGets the range’s refers to.
has_rangeIndicates whether this has range.
hyperlinksGets all hyperlink in the range.
cell_countGets all cell count in the range.
range_countGets the count of the ranges.
rangesGets all union ranges.

Methods

MethodDescription
set_outline_borders(self, border_styles, border_colors)Sets out line borders around a range of cells.
set_outline_borders(self, border_style, border_color)Sets the outline borders around a range of cells with same border style and color.
intersect(self, range)Intersects another range.
intersect(self, union_range)Intersects another range.
intersect(self, ranges)Intersects another range.
union(self, range)Union another range.
union(self, union_range)Union another range.
union(self, ranges)Union the ranges.
merge(self)Combines a range of cells into a single cell.
un_merge(self)Unmerges merged cells of this range.
put_value(self, string_value, is_converted, set_style)Puts a value into the range, if appropriate the value will be converted to other data type and cell’s number format will be reset.
set_style(self, style)Sets the style of the range.
apply_style(self, style, flag)Applies formats for a whole range.
copy(self, range, options)Copying the range with paste special options.
get_enumerator(self)Gets the enumerator for cells in this Range.

See Also