openpyxl.cell.text module¶
-
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:
openpyxl.styles.fonts.Font
Font 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 {‘single’, ‘singleAccounting’, ‘double’, ‘doubleAccounting’}
-
vertAlign
¶ Value must be one of {‘baseline’, ‘subscript’, ‘superscript’}
-
-
class
openpyxl.cell.text.
PhoneticProperties
(fontId=None, type=None, alignment=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
alignment
¶ Value must be one of {‘center’, ‘distributed’, ‘noControl’, ‘left’}
-
fontId
¶ Values must be of type <class ‘int’>
-
tagname
= 'phoneticPr'¶
-
type
¶ Value must be one of {‘fullwidthKatakana’, ‘halfwidthKatakana’, ‘noConversion’, ‘Hiragana’}
-
-
class
openpyxl.cell.text.
PhoneticText
(sb=None, eb=None, t=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.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 descriptve name is desired (eg. “underline” for “u”)
-
-
class
openpyxl.cell.text.
RichText
(rPr=None, t=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
font
¶ Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptve 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 descriptve name is desired (eg. “underline” for “u”)
-
-
class
openpyxl.cell.text.
Text
(t=None, r=(), rPh=(), phoneticPr=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
PhoneticProperties
¶ Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptve name is desired (eg. “underline” for “u”)
-
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 descriptve 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 descriptve 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 descriptve 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'¶
-