openpyxl.chart.reference module

class openpyxl.chart.reference.DummyWorksheet(title)

基类：object

class openpyxl.chart.reference.Reference(worksheet=None, min_col=None, min_row=None, max_col=None, max_row=None, range_string=None)

基类：openpyxl.descriptors.Strict

Normalise cell range references

property cols

Return all columns in the range

max_col

Values must be of type <class ‘int’>

max_row

Values must be of type <class ‘int’>

min_col

Values must be of type <class ‘int’>

min_row

Values must be of type <class ‘int’>

pop()

Return and remove the first cell

range_string

Values must be of type <class ‘str’>

property rows

Return all rows in the range

property sheetname