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: 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 {‘singleAccounting’, ‘single’, ‘doubleAccounting’, ‘double’}

vertAlign

Value must be one of {‘subscript’, ‘baseline’, ‘superscript’}

class openpyxl.cell.text.PhoneticProperties(fontId=None, type=None, alignment=None)[source]

Bases: Serialisable

alignment

Value must be one of {‘noControl’, ‘center’, ‘distributed’, ‘left’}

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

Values must be of type <class ‘str’>

class openpyxl.cell.text.RichText(rPr=None, t=None)[source]

Bases: Serialisable

font

Values must be of type <class ‘openpyxl.cell.text.InlineFont’>

rPr

Values must be of type <class ‘openpyxl.cell.text.InlineFont’>

t

Values must be of type <class ‘str’>

tagname = 'RElt'
text

Values must be of type <class ‘str’>

class openpyxl.cell.text.Text(t=None, r=(), rPh=(), phoneticPr=None)[source]

Bases: Serialisable

PhoneticProperties

Values must be of type <class ‘openpyxl.cell.text.PhoneticProperties’>

property content

Text stripped of all formatting

formatted

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

phonetic

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

phoneticPr

Values must be of type <class ‘openpyxl.cell.text.PhoneticProperties’>

plain

Values must be of type <class ‘str’>

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'