openpyxl.styles.table module
- class openpyxl.styles.table.TableStyle(name=None, pivot=None, table=None, count=None, tableStyleElement=())[source]
Bases:
Serialisable- count
Values must be of type <class ‘int’>
- name
Values must be of type <class ‘str’>
- pivot
Values must be of type <class ‘bool’>
- table
Values must be of type <class ‘bool’>
- tableStyleElement
A sequence (list or tuple) that may only contain objects of the declared type
- tagname = 'tableStyle'
- class openpyxl.styles.table.TableStyleElement(type=None, size=None, dxfId=None)[source]
Bases:
Serialisable- dxfId
Values must be of type <class ‘int’>
- size
Values must be of type <class ‘int’>
- tagname = 'tableStyleElement'
- type
Value must be one of {‘firstRowStripe’, ‘firstTotalCell’, ‘firstSubtotalRow’, ‘wholeTable’, ‘thirdSubtotalColumn’, ‘lastColumn’, ‘firstColumnStripe’, ‘firstSubtotalColumn’, ‘secondSubtotalRow’, ‘thirdRowSubheading’, ‘firstRowSubheading’, ‘secondColumnSubheading’, ‘secondSubtotalColumn’, ‘lastHeaderCell’, ‘pageFieldValues’, ‘thirdColumnSubheading’, ‘firstHeaderCell’, ‘firstColumn’, ‘pageFieldLabels’, ‘totalRow’, ‘headerRow’, ‘blankRow’, ‘secondRowSubheading’, ‘thirdSubtotalRow’, ‘firstColumnSubheading’, ‘lastTotalCell’, ‘secondRowStripe’, ‘secondColumnStripe’}
- class openpyxl.styles.table.TableStyleList(count=None, defaultTableStyle='TableStyleMedium9', defaultPivotStyle='PivotStyleLight16', tableStyle=())[source]
Bases:
Serialisable- property count
- defaultPivotStyle
Values must be of type <class ‘str’>
- defaultTableStyle
Values must be of type <class ‘str’>
- tableStyle
A sequence (list or tuple) that may only contain objects of the declared type
- tagname = 'tableStyles'