openpyxl.chart.text module

class openpyxl.chart.text.RichText(bodyPr=None, lstStyle=None, p=None)[source]

Bases: Serialisable

From the specification: 21.2.2.216

This element specifies text formatting. The lstStyle element is not supported.

bodyPr: Values must be of type <class ‘openpyxl.drawing.text.RichTextProperties’>

lstStyle: Values must be of type <class ‘openpyxl.drawing.text.ListStyle’>

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

paragraphs: Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)

properties: Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)

tagname = 'rich'

class openpyxl.chart.text.Text(strRef=None, rich=None)[source]

Bases: Serialisable

The value can be either a cell reference or a text element If both are present then the reference will be used.

rich: Values must be of type <class ‘openpyxl.chart.text.RichText’>

strRef: Values must be of type <class ‘openpyxl.chart.data_source.StrRef’>

tagname = 'tx'

to_tree(tagname=None, idx=None, namespace=None)[source]