Click or drag to resize

PivotTableElement Enumeration

// Represents PivotStyleMedium28 style. //
// Represents PivotStyleMedium27 style. //
// Represents PivotStyleMedium26 style. //
// Represents PivotStyleMedium25 style. //
// Represents PivotStyleMedium24 style. //
// Represents PivotStyleMedium23 style. //
// Represents PivotStyleMedium22 style. //
// Represents PivotStyleMedium21 style. //
// Represents PivotStyleMedium20 style. //
// Represents PivotStyleMedium19 style. //
// Represents PivotStyleMedium18 style. //
// Represents PivotStyleMedium17 style. //
// Represents PivotStyleMedium16 style. //
// Represents PivotStyleMedium15 style. //
// Represents PivotStyleMedium14 style. //
// Represents PivotStyleMedium13 style. //
// Represents PivotStyleMedium12 style. //
// Represents PivotStyleMedium11 style. //
// Represents PivotStyleMedium10 style. //
// Represents PivotStyleMedium9 style. //
// Represents PivotStyleMedium8 style. //
// Represents PivotStyleMedium7 style. //
// Represents PivotStyleMedium6 style. //
// Represents PivotStyleMedium5 style. //
// Represents PivotStyleMedium4 style. //
// Represents PivotStyleMedium3 style. //
// Represents PivotStyleMedium2 style. //
// Represents PivotStyleMedium1 style. //
// Represents PivotStyleLight28 style. //
// Represents PivotStyleLight27 style. //
// Represents PivotStyleLight26 style. //
// Represents PivotStyleLight25 style. //
// Represents PivotStyleLight24 style. //
// Represents PivotStyleLight23 style. //
// Represents PivotStyleLight22 style. //
// Represents PivotStyleLight21 style. //
// Represents PivotStyleLight20 style. //
// Represents PivotStyleLight19 style. //
// Represents PivotStyleLight18 style. //
// Represents PivotStyleLight17 style. //
// Represents PivotStyleLight16 style. //
// Represents PivotStyleLight15 style. //
// Represents PivotStyleLight14 style. //
// Represents PivotStyleLight13 style. //
// Represents PivotStyleLight12 style. //
// Represents PivotStyleLight11 style. //
// Represents PivotStyleLight10 style. //
// Represents PivotStyleLight9 style. //
// Represents PivotStyleLight8 style. //
// Represents PivotStyleLight7 style. //
// Represents PivotStyleLight6 style. //
// Represents PivotStyleLight5 style. //
// Represents PivotStyleLight4 style. //
// Represents PivotStyleLight3 style. //
// Represents PivotStyleLight2 style. //
// Represents PivotStyleLight1 style. //
// Represents PivotStyleDark28 style. //
// Represents PivotStyleDark27 style. //
// Represents PivotStyleDark26 style. //
// Represents PivotStyleDark25 style. //
// Represents PivotStyleDark24 style. //
// Represents PivotStyleDark23 style. //
// Represents PivotStyleDark22 style. //
// Represents PivotStyleDark21 style. //
// Represents PivotStyleDark20 style. //
// Represents PivotStyleDark19 style. //
// Represents PivotStyleDark18 style. //
// Represents PivotStyleDark17 style. //
// Represents PivotStyleDark16 style. //
// Represents PivotStyleDark15 style. //
// Represents PivotStyleDark14 style. //
// Represents PivotStyleDark13 style. //
// Represents PivotStyleDark12 style. //
// Represents PivotStyleDark11 style. //
// Represents PivotStyleDark10 style. //
// Represents PivotStyleDark9 style. //
// Represents PivotStyleDark8 style. //
// Represents PivotStyleDark7 style. //
// Represents PivotStyleDark6 style. //
// Represents PivotStyleDark5 style. //
// Represents PivotStyleDark4 style. //
// Represents PivotStyleDark3 style. //
// Represents PivotStyleDark2 style. //
// Represents PivotStyleDark1 style. //

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public enum PivotTableElement
Members
Member name Value Description
wholeTable 0
pageFieldLabels 1
pageFieldValues 2
firstColumnStripe 3
secondColumnStripe 4
firstRowStripe 5
secondRowStripe 6
firstColumn 7
headerRow 8
firstHeaderCell 9
firstSubtotalColumn 10
secondSubtotalColumn 11
thirdSubtotalColumn 12
blankRow 13
firstSubtotalRow 14
secondSubtotalRow 15
thirdSubtotalRow 16
firstColumnSubheading 17
secondColumnSubheading 18
thirdColumnSubheading 19
firstRowSubheading 20
secondRowSubheading 21
thirdRowSubheading 22
lastColumn 23
totalRow 24
See Also