# openpyxl.pivot.fields module

class openpyxl.pivot.fields.Boolean(x=(), v=None, u=None, f=None, c=None, cp=None)

  Bases: `Serialisable`

  c

    Values must be of type <class ‘str’>

  cp

    Values must be of type <class ‘int’>

  f

    Values must be of type <class ‘bool’>

  tagname = 'b'
  u

    Values must be of type <class ‘bool’>

  v

    Values must be of type <class ‘bool’>

  x

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

class openpyxl.pivot.fields.DateTimeField(x=(), v=None, u=None, f=None, c=None, cp=None)

  Bases: `Serialisable`

  c

    Values must be of type <class ‘str’>

  cp

    Values must be of type <class ‘int’>

  f

    Values must be of type <class ‘bool’>

  tagname = 'd'
  u

    Values must be of type <class ‘bool’>

  v

    Values must be of type <class ‘datetime.datetime’>

  x

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

class openpyxl.pivot.fields.Error(tpls=None, x=(), v=None, u=None, f=None, c=None, cp=None, _in=None, bc=None, fc=None, i=None, un=None, st=None, b=None)

  Bases: `Serialisable`

  b

    Values must be of type <class ‘bool’>

  bc
  c

    Values must be of type <class ‘str’>

  cp

    Values must be of type <class ‘int’>

  f

    Values must be of type <class ‘bool’>

  fc
  i

    Values must be of type <class ‘bool’>

  st

    Values must be of type <class ‘bool’>

  tagname = 'e'
  tpls

    Values must be of type <class ‘openpyxl.pivot.fields.TupleList’>

  u

    Values must be of type <class ‘bool’>

  un

    Values must be of type <class ‘bool’>

  v

    Values must be of type <class ‘str’>

  x

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

class openpyxl.pivot.fields.Index(v=0)

  Bases: `Serialisable`

  tagname = 'x'
  v

    Values must be of type <class ‘int’>

class openpyxl.pivot.fields.Missing(tpls=(), x=(), u=None, f=None, c=None, cp=None, _in=None, bc=None, fc=None, i=None, un=None, st=None, b=None)

  Bases: `Serialisable`

  b

    Values must be of type <class ‘bool’>

  bc
  c

    Values must be of type <class ‘str’>

  cp

    Values must be of type <class ‘int’>

  f

    Values must be of type <class ‘bool’>

  fc
  i

    Values must be of type <class ‘bool’>

  st

    Values must be of type <class ‘bool’>

  tagname = 'm'
  tpls

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

  u

    Values must be of type <class ‘bool’>

  un

    Values must be of type <class ‘bool’>

  x

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

class openpyxl.pivot.fields.Number(tpls=(), x=(), v=None, u=None, f=None, c=None, cp=None, _in=None, bc=None, fc=None, i=None, un=None, st=None, b=None)

  Bases: `Serialisable`

  b

    Values must be of type <class ‘bool’>

  bc
  c

    Values must be of type <class ‘str’>

  cp

    Values must be of type <class ‘int’>

  f

    Values must be of type <class ‘bool’>

  fc
  i

    Values must be of type <class ‘bool’>

  st

    Values must be of type <class ‘bool’>

  tagname = 'n'
  tpls

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

  u

    Values must be of type <class ‘bool’>

  un

    Values must be of type <class ‘bool’>

  v

    Values must be of type <class ‘float’>

  x

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

class openpyxl.pivot.fields.Text(tpls=(), x=(), v=None, u=None, f=None, c=None, cp=None, _in=None, bc=None, fc=None, i=None, un=None, st=None, b=None)

  Bases: `Serialisable`

  b

    Values must be of type <class ‘bool’>

  bc
  c

    Values must be of type <class ‘str’>

  cp

    Values must be of type <class ‘int’>

  f

    Values must be of type <class ‘bool’>

  fc
  i

    Values must be of type <class ‘bool’>

  st

    Values must be of type <class ‘bool’>

  tagname = 's'
  tpls

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

  u

    Values must be of type <class ‘bool’>

  un

    Values must be of type <class ‘bool’>

  v

    Values must be of type <class ‘str’>

  x

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

class openpyxl.pivot.fields.Tuple(fld=None, hier=None, item=None)

  Bases: `Serialisable`

  fld

    Values must be of type <class ‘int’>

  hier

    Values must be of type <class ‘int’>

  item

    Values must be of type <class ‘int’>

  tagname = 'tpl'

class openpyxl.pivot.fields.TupleList(c=None, tpl=None)

  Bases: `Serialisable`

  c

    Values must be of type <class ‘int’>

  tagname = 'tpls'
  tpl

    Values must be of type <class ‘openpyxl.pivot.fields.Tuple’>