CellRange {xlcharts}

CellRange

Description

Represents a range in a sheet: title and coordinates.

https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.cell_range.html

Usage

CellRange(
  range_string = NULL,
  min_col = NULL,
  min_row = NULL,
  max_col = NULL,
  max_row = NULL,
  title = NULL,
  ...
)

Arguments

range_string

range_string

min_col

min_col

min_row

min_row

max_col

max_col

max_row

max_row

title

title

...

Additional arguments, i.e. kwargs.

Details

This object is used to perform operations on ranges, like: - shift, expand or shrink - union/intersection with another sheet range, We can check whether a range is: - equal or not equal to another, - disjoint of another, - contained in another. We can get: - the size of a range. - the range bounds (vertices) - the coordinates, - the string representation,

Value

An openpyxl Python object.

Examples

## Not run: 
CellRange(range_string = "A1")

## End(Not run)