openpyxl.drawing.line module

class openpyxl.drawing.line.DashStop(d=0, sp=0)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

d

Values must be of type <class ‘int’>

length

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

namespace = 'http://schemas.openxmlformats.org/drawingml/2006/main'
sp

Values must be of type <class ‘int’>

space

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

tagname = 'ds'
class openpyxl.drawing.line.DashStopList(ds=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

ds

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

class openpyxl.drawing.line.LineEndProperties(type=None, w=None, len=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

len

Value must be one of {‘lg’, ‘sm’, ‘med’}

namespace = 'http://schemas.openxmlformats.org/drawingml/2006/main'
tagname = 'end'
type

Value must be one of {‘diamond’, ‘none’, ‘oval’, ‘arrow’, ‘stealth’, ‘triangle’}

w

Value must be one of {‘lg’, ‘sm’, ‘med’}

class openpyxl.drawing.line.LineProperties(w=None, cap=None, cmpd=None, algn=None, noFill=None, solidFill=None, gradFill=None, pattFill=None, prstDash=None, custDash=None, round=None, bevel=None, miter=None, headEnd=None, tailEnd=None, extLst=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

algn

Value must be one of {‘in’, ‘ctr’}

bevel

Values must be of type <class ‘bool’>

cap

Value must be one of {‘rnd’, ‘sq’, ‘flat’}

cmpd

Value must be one of {‘sng’, ‘dbl’, ‘thickThin’, ‘tri’, ‘thinThick’}

custDash

Values must be of type <class ‘openpyxl.drawing.line.DashStop’>

dashStyle

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

extLst

Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

gradFill

Values must be of type <class ‘openpyxl.drawing.fill.GradientFillProperties’>

headEnd

Values must be of type <class ‘openpyxl.drawing.line.LineEndProperties’>

miter

Values must be of type <class ‘int’>

namespace = 'http://schemas.openxmlformats.org/drawingml/2006/main'
noFill

Values must be of type <class ‘bool’>

pattFill

Values must be of type <class ‘openpyxl.drawing.fill.PatternFillProperties’>

prstDash

Value must be one of {‘sysDot’, ‘sysDash’, ‘solid’, ‘lgDashDot’, ‘dash’, ‘lgDash’, ‘dashDot’, ‘dot’, ‘sysDashDot’, ‘lgDashDotDot’, ‘sysDashDotDot’}

round

Values must be of type <class ‘bool’>

solidFill

Values must be of type <class ‘openpyxl.drawing.colors.ColorChoice’>

tagname = 'ln'
tailEnd

Values must be of type <class ‘openpyxl.drawing.line.LineEndProperties’>

w

Values must be of type <class ‘float’>

width

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