openpyxl.styles.table module

class openpyxl.styles.table.TableStyle(name=None, pivot=None, table=None, count=None, tableStyleElement=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

count

Values must be of type <type ‘long’>

name

Values must be of type <type ‘basestring’>

pivot

Values must be of type <type ‘bool’>

table

Values must be of type <type ‘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)

Bases: openpyxl.descriptors.serialisable.Serialisable

dxfId

Values must be of type <type ‘long’>

size

Values must be of type <type ‘long’>

tagname = 'tableStyleElement'

type

Value must be one of set([‘headerRow’, ‘pageFieldLabels’, ‘firstSubtotalRow’, ‘firstColumn’, ‘lastTotalCell’, ‘firstRowStripe’, ‘firstColumnStripe’, ‘secondColumnStripe’, ‘thirdColumnSubheading’, ‘secondRowStripe’, ‘lastHeaderCell’, ‘secondRowSubheading’, ‘thirdSubtotalRow’, ‘thirdSubtotalColumn’, ‘wholeTable’, ‘pageFieldValues’, ‘firstRowSubheading’, ‘secondSubtotalColumn’, ‘firstColumnSubheading’, ‘thirdRowSubheading’, ‘totalRow’, ‘secondSubtotalRow’, ‘lastColumn’, ‘firstHeaderCell’, ‘firstSubtotalColumn’, ‘secondColumnSubheading’, ‘blankRow’, ‘firstTotalCell’])

class openpyxl.styles.table.TableStyleList(count=None, defaultTableStyle='TableStyleMedium9', defaultPivotStyle='PivotStyleLight16', tableStyle=())

Bases: openpyxl.descriptors.serialisable.Serialisable

count

defaultPivotStyle

Values must be of type <type ‘basestring’>

defaultTableStyle

Values must be of type <type ‘basestring’>

tableStyle

A sequence (list or tuple) that may only contain objects of the declared type

tagname = 'tableStyles'