openpyxl.cell.text module
Richtext definition
- class openpyxl.cell.text.InlineFont(rFont=None, charset=None, family=None, b=None, i=None, strike=None, outline=None, shadow=None, condense=None, extend=None, color=None, sz=None, u=None, vertAlign=None, scheme=None)[source]
Bases:
FontFont for inline text because, yes what you need are different objects with the same elements but different constraints.
- b
Values must be of type <class ‘bool’>
- charset
Values must be of type <class ‘int’>
- color
Values must be of type <class ‘openpyxl.styles.colors.Color’>
- condense
Values must be of type <class ‘bool’>
- extend
Values must be of type <class ‘bool’>
- family
Values must be of type <class ‘float’>
- i
Values must be of type <class ‘bool’>
- outline
Values must be of type <class ‘bool’>
- rFont
Values must be of type <class ‘str’>
- scheme
Value must be one of {‘minor’, ‘major’}
- shadow
Values must be of type <class ‘bool’>
- strike
Values must be of type <class ‘bool’>
- sz
Values must be of type <class ‘float’>
- tagname = 'RPrElt'
- u
Value must be one of {‘double’, ‘doubleAccounting’, ‘singleAccounting’, ‘single’}
- vertAlign
Value must be one of {‘superscript’, ‘baseline’, ‘subscript’}
- class openpyxl.cell.text.PhoneticProperties(fontId=None, type=None, alignment=None)[source]
Bases:
Serialisable- alignment
Value must be one of {‘distributed’, ‘left’, ‘center’, ‘noControl’}
- fontId
Values must be of type <class ‘int’>
- tagname = 'phoneticPr'
- type
Value must be one of {‘fullwidthKatakana’, ‘halfwidthKatakana’, ‘Hiragana’, ‘noConversion’}
- class openpyxl.cell.text.PhoneticText(sb=None, eb=None, t=None)[source]
Bases:
Serialisable- eb
Values must be of type <class ‘int’>
- sb
Values must be of type <class ‘int’>
- t
Values must be of type <class ‘str’>
- tagname = 'rPh'
- text
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”)
- class openpyxl.cell.text.RichText(rPr=None, t=None)[source]
Bases:
Serialisable- font
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”)
- rPr
Values must be of type <class ‘openpyxl.cell.text.InlineFont’>
- t
Values must be of type <class ‘str’>
- tagname = 'RElt'
- text
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”)
- class openpyxl.cell.text.Text(t=None, r=(), rPh=(), phoneticPr=None)[source]
Bases:
Serialisable- PhoneticProperties
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”)
- property content
Text stripped of all formatting
- formatted
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”)
- phonetic
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”)
- phoneticPr
Values must be of type <class ‘openpyxl.cell.text.PhoneticProperties’>
- plain
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”)
- r
A sequence (list or tuple) that may only contain objects of the declared type
- rPh
A sequence (list or tuple) that may only contain objects of the declared type
- t
Values must be of type <class ‘str’>
- tagname = 'text'
