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
library("xlcharts")
CellRange(range_string = "A1")