expand_cell_ranges

Source code

Description

Expand cell ranges to a sequence of addresses.

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

Usage

expand_cell_ranges(range_string, ...)

Arguments

range_string	range_string
…	Additional arguments, i.e. kwargs.

Details

Reverse of collapse_cell_addresses Eg. converts "A1:A2 B1:B2" to (A1, A2, B1, B2)

Value

An Python builtin object.

Examples

library("xlcharts")

expand_cell_ranges(range_string = "A1:A2")