openpyxl.styles.fonts module

class openpyxl.styles.fonts.Font(name=None, sz=None, b=None, i=None, charset=None, u=None, strike=None, color=None, scheme=None, family=None, size=None, bold=None, italic=None, strikethrough=None, underline=None, vertAlign=None, outline=None, shadow=None, condense=None, extend=None)

Bases: Serialisable

Font options used in styles.

UNDERLINE_DOUBLE = 'double'

UNDERLINE_DOUBLE_ACCOUNTING = 'doubleAccounting'

UNDERLINE_SINGLE = 'single'

UNDERLINE_SINGLE_ACCOUNTING = 'singleAccounting'

b

Values must be of type <class ‘bool’>

bold

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’>

classmethod from_tree(node)

Set default value for underline if child element is present

i

Values must be of type <class ‘bool’>

italic

Values must be of type <class ‘bool’>

name

Values must be of type <class ‘str’>

outline

Values must be of type <class ‘bool’>

scheme

Value must be one of {‘minor’, ‘major’}

shadow

Values must be of type <class ‘bool’>

size

Values must be of type <class ‘float’>

strike

Values must be of type <class ‘bool’>

strikethrough

Values must be of type <class ‘bool’>

sz

Values must be of type <class ‘float’>

tagname = 'font'

u

Value must be one of {‘double’, ‘singleAccounting’, ‘doubleAccounting’, ‘single’}

underline

Value must be one of {‘double’, ‘singleAccounting’, ‘doubleAccounting’, ‘single’}

vertAlign

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