# 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)

  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 [‘major’, ‘minor’]

  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’, ‘single’, ‘singleAccounting’]

  vertAlign

    Value must be one of [‘baseline’, ‘subscript’, ‘superscript’]

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

  Bases: `Serialisable`

  alignment

    Value must be one of [‘center’, ‘distributed’, ‘left’, ‘noControl’]

  fontId

    Values must be of type <class ‘int’>

  tagname = 'phoneticPr'
  type

    Value must be one of [‘Hiragana’, ‘fullwidthKatakana’, ‘halfwidthKatakana’, ‘noConversion’]

class openpyxl.cell.text.PhoneticText(sb=None, eb=None, t=None)

  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)

  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)

  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'