openpyxl.styles.cell_style module
- class openpyxl.styles.cell_style.CellStyle(numFmtId=0, fontId=0, fillId=0, borderId=0, xfId=None, quotePrefix=None, pivotButton=None, applyNumberFormat=None, applyFont=None, applyFill=None, applyBorder=None, applyAlignment=None, applyProtection=None, alignment=None, protection=None, extLst=None)[source]
Bases:
Serialisable- alignment
Values must be of type <class ‘openpyxl.styles.alignment.Alignment’>
- property applyAlignment
- applyBorder
Values must be of type <class ‘bool’>
- applyFill
Values must be of type <class ‘bool’>
- applyFont
Values must be of type <class ‘bool’>
- applyNumberFormat
Values must be of type <class ‘bool’>
- property applyProtection
- borderId
Values must be of type <class ‘int’>
- extLst
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
- fillId
Values must be of type <class ‘int’>
- fontId
Values must be of type <class ‘int’>
- numFmtId
Values must be of type <class ‘int’>
- pivotButton
Values must be of type <class ‘bool’>
- protection
Values must be of type <class ‘openpyxl.styles.protection.Protection’>
- quotePrefix
Values must be of type <class ‘bool’>
- tagname = 'xf'
- xfId
Values must be of type <class ‘int’>
- class openpyxl.styles.cell_style.CellStyleList(count=None, xf=())[source]
Bases:
Serialisable- alignment
A sequence (list or tuple) that may only contain objects of the declared type
- property count
- protection
A sequence (list or tuple) that may only contain objects of the declared type
- tagname = 'cellXfs'
- xf
A sequence (list or tuple) that may only contain objects of the declared type