openpyxl.styles.table module¶
-
class
openpyxl.styles.table.
TableStyle
(name=None, pivot=None, table=None, count=None, tableStyleElement=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.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
¶ Values must be of type <class ‘openpyxl.styles.table.TableStyleElement’>
-
tagname
= 'tableStyle'¶
-
-
class
openpyxl.styles.table.
TableStyleElement
(type=None, size=None, dxfId=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.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 {‘secondRowStripe’, ‘lastHeaderCell’, ‘firstSubtotalColumn’, ‘wholeTable’, ‘thirdSubtotalColumn’, ‘firstSubtotalRow’, ‘thirdSubtotalRow’, ‘secondSubtotalColumn’, ‘firstTotalCell’, ‘thirdColumnSubheading’, ‘firstColumnSubheading’, ‘secondColumnSubheading’, ‘totalRow’, ‘headerRow’, ‘firstColumnStripe’, ‘secondSubtotalRow’, ‘lastColumn’, ‘firstRowStripe’, ‘firstHeaderCell’, ‘lastTotalCell’, ‘firstRowSubheading’, ‘blankRow’, ‘thirdRowSubheading’, ‘pageFieldLabels’, ‘secondColumnStripe’, ‘secondRowSubheading’, ‘firstColumn’, ‘pageFieldValues’}
-
-
class
openpyxl.styles.table.
TableStyleList
(count=None, defaultTableStyle='TableStyleMedium9', defaultPivotStyle='PivotStyleLight16', tableStyle=())[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
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'¶
-