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 {‘sm’, ‘lg’, ‘med’}
-
namespace
= 'http://schemas.openxmlformats.org/drawingml/2006/main'¶
-
tagname
= 'end'¶
-
type
¶ Value must be one of {‘none’, ‘stealth’, ‘triangle’, ‘diamond’, ‘arrow’, ‘oval’}
-
w
¶ Value must be one of {‘sm’, ‘lg’, ‘med’}
-
-
class
openpyxl.drawing.line.
LineJoinMiterProperties
(lim=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
lim
¶ Values must be of type <class ‘int’>
-
namespace
= 'http://schemas.openxmlformats.org/drawingml/2006/main'¶
-
tagname
= 'miter'¶
-
-
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, mitre=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 {‘dbl’, ‘thinThick’, ‘sng’, ‘tri’, ‘thickThin’}
-
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 ‘openpyxl.drawing.line.LineJoinMiterProperties’>
-
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 {‘lgDashDot’, ‘dash’, ‘solid’, ‘lgDash’, ‘dashDot’, ‘sysDash’, ‘sysDashDotDot’, ‘lgDashDotDot’, ‘dot’, ‘sysDashDot’, ‘sysDot’}
-
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”)
-