openpyxl.worksheet.scenario module¶
- class openpyxl.worksheet.scenario.InputCells(r=None, deleted=False, undone=False, val=None, numFmtId=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- deleted¶
Values must be of type <class ‘bool’>
- numFmtId¶
Values must be of type <class ‘int’>
- r¶
Values must be of type <class ‘str’>
- tagname = 'inputCells'¶
- undone¶
Values must be of type <class ‘bool’>
- val¶
Values must be of type <class ‘str’>
- class openpyxl.worksheet.scenario.Scenario(inputCells=(), name=None, locked=False, hidden=False, count=None, user=None, comment=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- comment¶
Values must be of type <class ‘str’>
- property count¶
Values must be of type <class ‘bool’>
- inputCells¶
A sequence (list or tuple) that may only contain objects of the declared type
- locked¶
Values must be of type <class ‘bool’>
- name¶
Values must be of type <class ‘str’>
- tagname = 'scenario'¶
- user¶
Values must be of type <class ‘str’>
- class openpyxl.worksheet.scenario.ScenarioList(scenario=(), current=None, show=None, sqref=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- current¶
Values must be of type <class ‘int’>
- scenario¶
A sequence (list or tuple) that may only contain objects of the declared type
- show¶
Values must be of type <class ‘int’>
- sqref¶
Values must be of type <class ‘openpyxl.worksheet.cell_range.MultiCellRange’>
- tagname = 'scenarios'¶
