openpyxl.worksheet.pivot module¶
-
class
openpyxl.worksheet.pivot.Index(v=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable-
v¶ Values must be of type <type ‘long’>
-
-
class
openpyxl.worksheet.pivot.PivotArea(field=None, type=None, dataOnly=None, labelOnly=None, grandRow=None, grandCol=None, cacheIndex=None, outline=None, offset=None, collapsedLevelsAreSubtotals=None, axis=None, fieldPosition=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable-
axis¶ Values must be of type <type ‘basestring’>
-
cacheIndex¶ Values must be of type <type ‘bool’>
-
collapsedLevelsAreSubtotals¶ Values must be of type <type ‘bool’>
-
dataOnly¶ Values must be of type <type ‘bool’>
-
field¶ Values must be of type <type ‘long’>
-
fieldPosition¶ Values must be of type <type ‘long’>
-
grandCol¶ Values must be of type <type ‘bool’>
-
grandRow¶ Values must be of type <type ‘bool’>
-
labelOnly¶ Values must be of type <type ‘bool’>
-
offset¶ Values must be of type <type ‘basestring’>
-
outline¶ Values must be of type <type ‘bool’>
-
type¶ Value must be one of set([‘origin’, ‘all’, ‘normal’, ‘button’, ‘data’, ‘topEnd’])
-
-
class
openpyxl.worksheet.pivot.PivotAreaReference(field=None, count=None, selected=None, byPosition=None, relative=None, defaultSubtotal=None, sumSubtotal=None, countASubtotal=None, avgSubtotal=None, maxSubtotal=None, minSubtotal=None, productSubtotal=None, countSubtotal=None, stdDevSubtotal=None, stdDevPSubtotal=None, varSubtotal=None, varPSubtotal=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable-
avgSubtotal¶ Values must be of type <type ‘bool’>
-
byPosition¶ Values must be of type <type ‘bool’>
-
count¶ Values must be of type <type ‘long’>
-
countASubtotal¶ Values must be of type <type ‘bool’>
-
countSubtotal¶ Values must be of type <type ‘bool’>
-
defaultSubtotal¶ Values must be of type <type ‘bool’>
-
field¶ Values must be of type <type ‘long’>
-
maxSubtotal¶ Values must be of type <type ‘bool’>
-
minSubtotal¶ Values must be of type <type ‘bool’>
-
productSubtotal¶ Values must be of type <type ‘bool’>
-
relative¶ Values must be of type <type ‘bool’>
-
selected¶ Values must be of type <type ‘bool’>
-
stdDevPSubtotal¶ Values must be of type <type ‘bool’>
-
stdDevSubtotal¶ Values must be of type <type ‘bool’>
-
sumSubtotal¶ Values must be of type <type ‘bool’>
-
varPSubtotal¶ Values must be of type <type ‘bool’>
-
varSubtotal¶ Values must be of type <type ‘bool’>
-
-
class
openpyxl.worksheet.pivot.PivotAreaReferences(count=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable-
count¶ Values must be of type <type ‘long’>
-
-
class
openpyxl.worksheet.pivot.PivotSelection(pane=None, showHeader=None, label=None, data=None, extendable=None, count=None, axis=None, dimension=None, start=None, min=None, max=None, activeRow=None, activeCol=None, previousRow=None, previousCol=None, click=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable-
activeCol¶ Values must be of type <type ‘long’>
-
activeRow¶ Values must be of type <type ‘long’>
-
axis¶ Values must be of type <type ‘basestring’>
-
click¶ Values must be of type <type ‘long’>
-
count¶ Values must be of type <type ‘long’>
-
data¶ Values must be of type <type ‘bool’>
-
dimension¶ Values must be of type <type ‘long’>
-
extendable¶ Values must be of type <type ‘bool’>
-
label¶ Values must be of type <type ‘bool’>
-
max¶ Values must be of type <type ‘long’>
-
min¶ Values must be of type <type ‘long’>
-
pane¶ Value must be one of set([‘topLeft’, ‘bottomLeft’, ‘topRight’, ‘bottomRight’])
-
previousCol¶ Values must be of type <type ‘long’>
-
previousRow¶ Values must be of type <type ‘long’>
-
showHeader¶ Values must be of type <type ‘bool’>
-
start¶ Values must be of type <type ‘long’>
-