Skip to content

CellRange

Source code

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")