ItemValues Enumeration

PivotItem Type

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
Public Enumeration ItemValues
'Usage
Dim instance As ItemValues
public enum ItemValues

Members

Member name Description
Data Data. When the item is serialized out as xml, its value is "data".
Default Default. When the item is serialized out as xml, its value is "default".
Sum Sum. When the item is serialized out as xml, its value is "sum".
CountA CountA. When the item is serialized out as xml, its value is "countA".
Average Average. When the item is serialized out as xml, its value is "avg".
Maximum Max. When the item is serialized out as xml, its value is "max".
Minimum Min. When the item is serialized out as xml, its value is "min".
Product Product. When the item is serialized out as xml, its value is "product".
Count Count. When the item is serialized out as xml, its value is "count".
StandardDeviation stdDev. When the item is serialized out as xml, its value is "stdDev".
StandardDeviationP StdDevP. When the item is serialized out as xml, its value is "stdDevP".
Variance Var. When the item is serialized out as xml, its value is "var".
VarianceP VarP. When the item is serialized out as xml, its value is "varP".
Grand Grand Total Item. When the item is serialized out as xml, its value is "grand".
Blank Blank Pivot Item. When the item is serialized out as xml, its value is "blank".

See Also

Reference

DocumentFormat.OpenXml.Spreadsheet Namespace