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)[source]

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)[source]

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

underline

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

vertAlign

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