openpyxl.styles.table模块

class openpyxl.styles.table.TableStyle(name=None, pivot=None, table=None, count=None, tableStyleElement=None)[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

count

值的类型必须小于class“int”>

name

值的类型必须小于class'str'>

pivot

值的类型必须小于class'bool'>

table

值的类型必须小于class'bool'>

tableStyleElement

值的类型必须为<class'openpyxl.styles.table.tableStyleElement'>

tagname = 'tableStyle'
class openpyxl.styles.table.TableStyleElement(type=None, size=None, dxfId=None)[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

dxfId

值的类型必须小于class“int”>

size

值的类型必须小于class“int”>

tagname = 'tableStyleElement'
type

Value must be one of {'thirdColumnSubheading', 'firstColumnSubheading', 'thirdRowSubheading', 'firstSubtotalColumn', 'firstHeaderCell', 'secondColumnStripe', 'firstColumnStripe', 'secondRowStripe', 'secondSubtotalColumn', 'secondSubtotalRow', 'firstRowSubheading', 'pageFieldLabels', 'headerRow', 'lastTotalCell', 'lastColumn', 'thirdSubtotalRow', 'firstRowStripe', 'firstSubtotalRow', 'pageFieldValues', 'wholeTable', 'secondRowSubheading', 'secondColumnSubheading', 'blankRow', 'totalRow', 'firstColumn', 'lastHeaderCell', 'thirdSubtotalColumn', 'firstTotalCell'}

class openpyxl.styles.table.TableStyleList(count=None, defaultTableStyle='TableStyleMedium9', defaultPivotStyle='PivotStyleLight16', tableStyle=())[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

count
defaultPivotStyle

值的类型必须小于class'str'>

defaultTableStyle

值的类型必须小于class'str'>

tableStyle

只能包含声明类型的对象的序列(列表或元组)

tagname = 'tableStyles'