OpenPyXL 3.0.7
  • 教程
  • 简单用法
  • 性能
  • 优化模式
  • 插入和删除行和列,移动单元格范围
  • 操纵 Pandas 和 NumPy
  • 图表
  • 注释
  • 操控样式
  • 额外工作表特性
  • 条件格式化
  • 数据透视表
  • 打印设置
  • 使用过滤器和排序
  • 验证单元格
  • 定义名称
  • 工作表表格
  • 剖析公式
  • 日期和时间
  • 保护
  • 开发
  • openpyxl 包
  • 3.0.7 (2021-03-09)
  • 3.0.6 (2021-01-14)
  • 3.0.5 (2020-08-21)
  • 3.0.4 (2020-06-24)
  • 3.0.3 (2020-01-20)
  • 3.0.2 (2019-11-25)
  • 3.0.1 (2019-11-14)
  • 3.0.0 (2019-09-25)
  • 2.6.4 (2019-09-25)
  • 2.6.3 (2019-08-19)
  • 2.6.2 (2019-03-29)
  • 2.6.1 (2019-03-04)
  • 2.6.0 (2019-02-06)
  • 2.6.-b1 (2019-01-08)
  • 2.6-a1 (2018-11-21)
  • 2.5.14 (2019-01-23)
  • 2.5.13 (brown bag)
  • 2.5.12 (2018-11-29)
  • 2.5.11 (2018-11-21)
  • 2.5.10 (2018-11-13)
  • 2.5.9 (2018-10-19)
  • 2.5.8 (2018-09-25)
  • 2.5.7 (2018-09-13)
  • 2.5.6 (2018-08-30)
  • 2.5.5 (2018-08-04)
  • 2.5.4 (2018-06-07)
  • 2.5.3 (2018-04-18)
  • 2.5.2 (2018-04-06)
  • 2.5.1 (2018-03-12)
  • 2.5.0 (2018-01-24)
  • 2.5.0-b2 (2018-01-19)
  • 2.5.0-b1 (2017-10-19)
  • 2.5.0-a3 (2017-08-14)
  • 2.5.0-a2 (2017-06-25)
  • 2.5.0-a1 (2017-05-30)
  • 2.4.11 (2018-01-24)
  • 2.4.10 (2018-01-19)
  • 2.4.9 (2017-10-19)
  • 2.4.8 (2017-05-30)
  • 2.4.7 (2017-04-24)
  • 2.4.6 (2017-04-14)
  • 2.4.5 (2017-03-07)
  • 2.4.4 (2017-02-23)
  • 2.4.3 (未发行)
  • 2.4.2 (2017-01-31)
  • 2.4.1 (2016-11-23)
  • 2.4.0 (2016-09-15)
  • 2.4.0-b1 (2016-06-08)
  • 2.4.0-a1 (2016-04-11)
  • 2.3.5 (2016-04-11)
  • 2.3.4 (2016-03-16)
  • 2.3.3 (2016-01-18)
  • 2.3.2 (2015-12-07)
  • 2.3.1 (2015-11-20)
  • 2.3.0 (2015-10-20)
  • 2.3.0-b2 (2015-09-04)
  • 2.3.0-b1 (2015-06-29)
  • 2.2.6 (未发行)
  • 2.2.5 (2015-06-29)
  • 2.2.4 (2015-06-17)
  • 2.2.3 (2015-05-26)
  • 2.2.2 (2015-04-28)
  • 2.2.1 (2015-03-31)
  • 2.2.0 (2015-03-11)
  • 2.2.0-b1 (2015-02-18)
  • 2.1.5 (2015-02-18)
  • 2.1.4 (2014-12-16)
  • 2.1.3 (2014-12-09)
  • 2.1.2 (2014-10-23)
  • 2.1.1 (2014-10-08)
  • 2.1.0 (2014-09-21)
  • 2.0.5 (2014-08-08)
  • 2.0.4 (2014-06-25)
  • 2.0.3 (2014-05-22)
  • 2.0.2 (2014-05-13)
  • 2.0.1 (2014-05-13) brown bag
  • 2.0.0 (2014-05-13) brown bag
  • 1.8.6 (2014-05-05)
  • 1.8.5 (2014-03-25)
  • 1.8.4 (2014-02-25)
  • 1.8.3 (2014-02-09)
  • 1.8.2 (2014-01-17)
  • 1.8.1 (2014-01-14)
  • 1.8.0 (2014-01-08)
  • 1.7.0 (2013-10-31)
  • openpyxl.drawing.geometry 模块

    class openpyxl.drawing.geometry. AdjPoint2D ( x=None , y=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    x

    Values must be of type <class ‘int’>

    y

    Values must be of type <class ‘int’>

    class openpyxl.drawing.geometry. AdjustHandleList [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    class openpyxl.drawing.geometry. Backdrop ( anchor=None , norm=None , up=None , extLst=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    anchor

    Values must be of type <class ‘openpyxl.drawing.geometry.Point3D’>

    extLst

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

    norm

    Values must be of type <class ‘openpyxl.drawing.geometry.Vector3D’>

    up

    Values must be of type <class ‘openpyxl.drawing.geometry.Vector3D’>

    class openpyxl.drawing.geometry. Bevel ( w=None , h=None , prst=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    h

    Values must be of type <class ‘int’>

    prst

    Value must be one of {‘convex’, ‘coolSlant’, ‘slope’, ‘relaxedInset’, ‘softRound’, ‘artDeco’, ‘angle’, ‘divot’, ‘hardEdge’, ‘circle’, ‘cross’, ‘riblet’}

    tagname = 'bevel'
    w

    Values must be of type <class ‘int’>

    class openpyxl.drawing.geometry. Camera ( prst=None , fov=None , zoom=None , rot=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    fov

    Values must be of type <class ‘int’>

    prst

    Value must be one of {‘legacyObliqueFront’, ‘perspectiveRelaxed’, ‘perspectiveHeroicExtremeLeftFacing’, ‘legacyPerspectiveFront’, ‘perspectiveRight’, ‘isometricOffAxis3Right’, ‘legacyPerspectiveTopLeft’, ‘isometricOffAxis4Left’, ‘perspectiveHeroicLeftFacing’, ‘perspectiveAboveRightFacing’, ‘isometricOffAxis3Bottom’, ‘legacyObliqueTopLeft’, ‘legacyPerspectiveBottomRight’, ‘isometricRightDown’, ‘legacyPerspectiveBottom’, ‘perspectiveHeroicRightFacing’, ‘isometricTopDown’, ‘isometricRightUp’, ‘obliqueTop’, ‘perspectiveRelaxedModerately’, ‘perspectiveBelow’, ‘isometricOffAxis1Top’, ‘perspectiveAboveLeftFacing’, ‘isometricOffAxis2Right’, ‘legacyObliqueTop’, ‘isometricTopUp’, ‘isometricOffAxis3Left’, ‘obliqueRight’, ‘legacyPerspectiveBottomLeft’, ‘legacyPerspectiveRight’, ‘isometricOffAxis4Right’, ‘isometricOffAxis2Top’, ‘isometricLeftDown’, ‘orthographicFront’, ‘isometricOffAxis4Bottom’, ‘obliqueBottomLeft’, ‘legacyObliqueBottomLeft’, ‘legacyPerspectiveLeft’, ‘legacyObliqueBottomRight’, ‘legacyPerspectiveTopRight’, ‘perspectiveContrastingLeftFacing’, ‘perspectiveAbove’, ‘isometricOffAxis1Right’, ‘perspectiveContrastingRightFacing’, ‘isometricOffAxis2Left’, ‘legacyObliqueLeft’, ‘isometricBottomDown’, ‘legacyObliqueTopRight’, ‘isometricOffAxis1Left’, ‘obliqueTopRight’, ‘isometricBottomUp’, ‘obliqueTopLeft’, ‘perspectiveHeroicExtremeRightFacing’, ‘legacyObliqueBottom’, ‘legacyPerspectiveTop’, ‘isometricLeftUp’, ‘perspectiveFront’, ‘perspectiveLeft’, ‘obliqueLeft’, ‘obliqueBottomRight’, ‘legacyObliqueRight’, ‘obliqueBottom’}

    rot

    Values must be of type <class ‘openpyxl.drawing.geometry.SphereCoords’>

    tagname = 'camera'
    zoom

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

    class openpyxl.drawing.geometry. ConnectionSite ( ang=None , pos=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    ang

    Values must be of type <class ‘float’>

    pos

    Values must be of type <class ‘openpyxl.drawing.geometry.AdjPoint2D’>

    class openpyxl.drawing.geometry. ConnectionSiteList ( cxn=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    cxn

    Values must be of type <class ‘openpyxl.drawing.geometry.ConnectionSite’>

    class openpyxl.drawing.geometry. CustomGeometry2D ( avLst=None , gdLst=None , ahLst=None , cxnLst=None , rect=None , pathLst=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    ahLst

    Values must be of type <class ‘openpyxl.drawing.geometry.AdjustHandleList’>

    avLst

    Values must be of type <class ‘openpyxl.drawing.geometry.GeomGuideList’>

    cxnLst

    Values must be of type <class ‘openpyxl.drawing.geometry.ConnectionSiteList’>

    gdLst

    Values must be of type <class ‘openpyxl.drawing.geometry.GeomGuideList’>

    pathLst

    Values must be of type <class ‘openpyxl.drawing.geometry.Path2DList’>

    class openpyxl.drawing.geometry. FontReference ( idx=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    idx

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

    class openpyxl.drawing.geometry. GeomGuide ( name=None , fmla=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    fmla

    Values must be of type <class ‘str’>

    name

    Values must be of type <class ‘str’>

    class openpyxl.drawing.geometry. GeomGuideList ( gd=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    gd

    Values must be of type <class ‘openpyxl.drawing.geometry.GeomGuide’>

    class openpyxl.drawing.geometry. GeomRect ( l=None , t=None , r=None , b=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    b

    Values must be of type <class ‘int’>

    l

    Values must be of type <class ‘int’>

    r

    Values must be of type <class ‘int’>

    t

    Values must be of type <class ‘int’>

    class openpyxl.drawing.geometry. GroupTransform2D ( rot=0 , flipH=None , flipV=None , off=None , ext=None , chOff=None , chExt=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    chExt

    Values must be of type <class ‘openpyxl.drawing.geometry.PositiveSize2D’>

    chOff

    Values must be of type <class ‘openpyxl.drawing.geometry.Point2D’>

    ext

    Values must be of type <class ‘openpyxl.drawing.geometry.PositiveSize2D’>

    flipH

    Values must be of type <class ‘bool’>

    flipV

    Values must be of type <class ‘bool’>

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

    Values must be of type <class ‘openpyxl.drawing.geometry.Point2D’>

    rot

    Values must be of type <class ‘int’>

    tagname = 'xfrm'
    class openpyxl.drawing.geometry. LightRig ( rig=None , dir=None , rot=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    dir

    Value must be one of {‘l’, ‘bl’, ‘r’, ‘t’, ‘tl’, ‘b’, ‘br’, ‘tr’}

    rig

    Value must be one of {‘freezing’, ‘threePt’, ‘sunrise’, ‘brightRoom’, ‘legacyHarsh4’, ‘legacyHarsh3’, ‘legacyHarsh1’, ‘flood’, ‘flat’, ‘twoPt’, ‘legacyFlat2’, ‘chilly’, ‘legacyFlat3’, ‘legacyFlat1’, ‘legacyNormal4’, ‘soft’, ‘balanced’, ‘contrasting’, ‘glow’, ‘legacyHarsh2’, ‘legacyNormal2’, ‘legacyNormal1’, ‘legacyFlat4’, ‘sunset’, ‘morning’, ‘harsh’, ‘legacyNormal3’}

    rot

    Values must be of type <class ‘openpyxl.drawing.geometry.SphereCoords’>

    tagname = 'lightRig'
    class openpyxl.drawing.geometry. Path2D ( w=None , h=None , fill=None , stroke=None , extrusionOk=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    extrusionOk

    Values must be of type <class ‘bool’>

    fill

    Value must be one of {‘norm’, ‘lightenLess’, ‘lighten’, ‘darken’, ‘darkenLess’}

    h

    Values must be of type <class ‘float’>

    stroke

    Values must be of type <class ‘bool’>

    w

    Values must be of type <class ‘float’>

    class openpyxl.drawing.geometry. Path2DList ( path=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    path

    Values must be of type <class ‘openpyxl.drawing.geometry.Path2D’>

    class openpyxl.drawing.geometry. Point2D ( x=None , y=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    namespace = 'http://schemas.openxmlformats.org/drawingml/2006/main'
    tagname = 'off'
    x

    Values must be of type <class ‘int’>

    y

    Values must be of type <class ‘int’>

    class openpyxl.drawing.geometry. Point3D ( x=None , y=None , z=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    tagname = 'anchor'
    x

    Values must be of type <class ‘int’>

    y

    Values must be of type <class ‘int’>

    z

    Values must be of type <class ‘int’>

    class openpyxl.drawing.geometry. PositiveSize2D ( cx=None , cy=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    cx

    Values must be of type <class ‘int’>

    cy

    Values must be of type <class ‘int’>

    height

    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'

    Dimensions in EMUs

    tagname = 'ext'
    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”)

    class openpyxl.drawing.geometry. PresetGeometry2D ( prst=None , avLst=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    avLst

    Values must be of type <class ‘openpyxl.drawing.geometry.GeomGuideList’>

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

    Value must be one of {‘leftCircularArrow’, ‘flowChartMagneticDisk’, ‘accentBorderCallout3’, ‘flowChartMerge’, ‘flowChartOnlineStorage’, ‘rightBracket’, ‘flowChartMagneticTape’, ‘squareTabs’, ‘actionButtonBlank’, ‘leftRightArrowCallout’, ‘bracketPair’, ‘curvedConnector3’, ‘borderCallout3’, ‘pieWedge’, ‘noSmoking’, ‘horizontalScroll’, ‘flowChartSort’, ‘upDownArrowCallout’, ‘swooshArrow’, ‘curvedConnector5’, ‘star7’, ‘hexagon’, ‘downArrow’, ‘star6’, ‘cornerTabs’, ‘flowChartPredefinedProcess’, ‘can’, ‘star5’, ‘bentConnector4’, ‘diagStripe’, ‘accentCallout3’, ‘ribbon2’, ‘decagon’, ‘frame’, ‘flowChartConnector’, ‘flowChartOffpageConnector’, ‘star16’, ‘accentCallout1’, ‘accentBorderCallout1’, ‘flowChartManualOperation’, ‘flowChartOr’, ‘curvedLeftArrow’, ‘leftArrowCallout’, ‘flowChartTerminator’, ‘snip2DiagRect’, ‘plaque’, ‘bentConnector3’, ‘round2SameRect’, ‘curvedDownArrow’, ‘actionButtonBackPrevious’, ‘wedgeRectCallout’, ‘line’, ‘chartX’, ‘star8’, ‘star24’, ‘round2DiagRect’, ‘leftBrace’, ‘callout1’, ‘mathEqual’, ‘chartStar’, ‘roundRect’, ‘snip2SameRect’, ‘foldedCorner’, ‘corner’, ‘gear9’, ‘flowChartInternalStorage’, ‘leftRightUpArrow’, ‘funnel’, ‘mathNotEqual’, ‘wedgeRoundRectCallout’, ‘gear6’, ‘notchedRightArrow’, ‘leftUpArrow’, ‘ellipse’, ‘circularArrow’, ‘bentConnector2’, ‘callout3’, ‘moon’, ‘flowChartManualInput’, ‘actionButtonInformation’, ‘dodecagon’, ‘mathMinus’, ‘nonIsoscelesTrapezoid’, ‘rect’, ‘uturnArrow’, ‘cloudCallout’, ‘downArrowCallout’, ‘quadArrowCallout’, ‘cloud’, ‘curvedConnector2’, ‘quadArrow’, ‘star32’, ‘arc’, ‘flowChartDocument’, ‘bracePair’, ‘actionButtonHelp’, ‘actionButtonReturn’, ‘star12’, ‘lightningBolt’, ‘donut’, ‘verticalScroll’, ‘flowChartPunchedCard’, ‘borderCallout2’, ‘flowChartMultidocument’, ‘teardrop’, ‘upDownArrow’, ‘flowChartCollate’, ‘plaqueTabs’, ‘flowChartSummingJunction’, ‘irregularSeal1’, ‘wave’, ‘actionButtonBeginning’, ‘flowChartExtract’, ‘wedgeEllipseCallout’, ‘heart’, ‘flowChartInputOutput’, ‘star10’, ‘snipRoundRect’, ‘bentUpArrow’, ‘curvedUpArrow’, ‘flowChartOfflineStorage’, ‘parallelogram’, ‘heptagon’, ‘smileyFace’, ‘pentagon’, ‘actionButtonSound’, ‘round1Rect’, ‘flowChartDelay’, ‘sun’, ‘callout2’, ‘upArrow’, ‘flowChartAlternateProcess’, ‘chord’, ‘actionButtonForwardNext’, ‘actionButtonDocument’, ‘flowChartDisplay’, ‘halfFrame’, ‘upArrowCallout’, ‘octagon’, ‘ribbon’, ‘chartPlus’, ‘actionButtonHome’, ‘mathMultiply’, ‘ellipseRibbon’, ‘accentBorderCallout2’, ‘plus’, ‘ellipseRibbon2’, ‘flowChartDecision’, ‘bevel’, ‘rightBrace’, ‘snip1Rect’, ‘leftRightRibbon’, ‘bentArrow’, ‘flowChartProcess’, ‘flowChartMagneticDrum’, ‘flowChartPreparation’, ‘leftArrow’, ‘irregularSeal2’, ‘diamond’, ‘doubleWave’, ‘leftRightArrow’, ‘stripedRightArrow’, ‘star4’, ‘cube’, ‘straightConnector1’, ‘actionButtonMovie’, ‘lineInv’, ‘curvedConnector4’, ‘homePlate’, ‘actionButtonEnd’, ‘mathDivide’, ‘rightArrow’, ‘bentConnector5’, ‘flowChartPunchedTape’, ‘blockArc’, ‘accentCallout2’, ‘rightArrowCallout’, ‘chevron’, ‘leftRightCircularArrow’, ‘trapezoid’, ‘curvedRightArrow’, ‘pie’, ‘mathPlus’, ‘borderCallout1’, ‘leftBracket’, ‘rtTriangle’, ‘triangle’}

    class openpyxl.drawing.geometry. Scene3D ( camera=None , lightRig=None , backdrop=None , extLst=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    backdrop

    Values must be of type <class ‘openpyxl.drawing.geometry.Backdrop’>

    camera

    Values must be of type <class ‘openpyxl.drawing.geometry.Camera’>

    extLst

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

    lightRig

    Values must be of type <class ‘openpyxl.drawing.geometry.LightRig’>

    class openpyxl.drawing.geometry. Shape3D ( z=None , extrusionH=None , contourW=None , prstMaterial=None , bevelT=None , bevelB=None , extrusionClr=None , contourClr=None , extLst=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    bevelB

    Values must be of type <class ‘openpyxl.drawing.geometry.Bevel’>

    bevelT

    Values must be of type <class ‘openpyxl.drawing.geometry.Bevel’>

    contourClr

    Values must be of type <class ‘openpyxl.styles.colors.Color’>

    contourW

    Values must be of type <class ‘int’>

    extLst

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

    extrusionClr

    Values must be of type <class ‘openpyxl.styles.colors.Color’>

    extrusionH

    Values must be of type <class ‘int’>

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

    Value must be one of {‘flat’, ‘legacyPlastic’, ‘metal’, ‘legacyMetal’, ‘powder’, ‘softEdge’, ‘warmMatte’, ‘plastic’, ‘legacyWireframe’, ‘dkEdge’, ‘softmetal’, ‘legacyMatte’, ‘translucentPowder’, ‘clear’, ‘matte’}

    z

    Values must be of type <class ‘openpyxl.descriptors.base.Integer’>

    class openpyxl.drawing.geometry. ShapeStyle ( lnRef=None , fillRef=None , effectRef=None , fontRef=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    effectRef

    Values must be of type <class ‘openpyxl.drawing.geometry.StyleMatrixReference’>

    fillRef

    Values must be of type <class ‘openpyxl.drawing.geometry.StyleMatrixReference’>

    fontRef

    Values must be of type <class ‘openpyxl.drawing.geometry.FontReference’>

    lnRef

    Values must be of type <class ‘openpyxl.drawing.geometry.StyleMatrixReference’>

    class openpyxl.drawing.geometry. SphereCoords ( lat=None , lon=None , rev=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    lat

    Values must be of type <class ‘int’>

    lon

    Values must be of type <class ‘int’>

    rev

    Values must be of type <class ‘int’>

    tagname = 'sphereCoords'
    class openpyxl.drawing.geometry. StyleMatrixReference ( idx=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    idx

    Values must be of type <class ‘int’>

    class openpyxl.drawing.geometry. Transform2D ( rot=None , flipH=None , flipV=None , off=None , ext=None , chOff=None , chExt=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    chExt

    Values must be of type <class ‘openpyxl.drawing.geometry.PositiveSize2D’>

    chOff

    Values must be of type <class ‘openpyxl.drawing.geometry.Point2D’>

    ext

    Values must be of type <class ‘openpyxl.drawing.geometry.PositiveSize2D’>

    flipH

    Values must be of type <class ‘bool’>

    flipV

    Values must be of type <class ‘bool’>

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

    Values must be of type <class ‘openpyxl.drawing.geometry.Point2D’>

    rot

    Values must be of type <class ‘int’>

    tagname = 'xfrm'
    class openpyxl.drawing.geometry. Vector3D ( dx=None , dy=None , dz=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    dx

    Values must be of type <class ‘int’>

    dy

    Values must be of type <class ‘int’>

    dz

    Values must be of type <class ‘int’>

    tagname = 'vector'