Aspose::Cells::Pivot Namespace Reference

Classes

class  IPivotField
 Represents a field in a PivotTable report. More...
 
class  IPivotFieldCollection
 Represents a collection of all the PivotField objects in the PivotTable's specific PivotFields type. More...
 
class  IPivotFilter
 Represents a PivotFilter in PivotFilter Collection. More...
 
class  IPivotFilterCollection
 Represents a collection of all the PivotFilter objects More...
 
class  IPivotFormatCondition
 Represents a PivotTable Format Condition in PivotFormatCondition Collection. More...
 
class  IPivotFormatConditionCollection
 Represents PivotTable Format Conditions. More...
 
class  IPivotItem
 Represents a item in a PivotField report. More...
 
class  IPivotItemCollection
 Represents a collection of all the PivotItem objects in the PivotField's More...
 
class  IPivotPageFields
 Represents the pivot page field items if the pivot table data source is consolidation ranges. It only can contain up to 4 fields. More...
 
class  IPivotTable
 Summary description for PivotTable. More...
 
class  IPivotTableCollection
 Represents the collection of all the PivotTable objects on the specified worksheet. More...
 
class  ISxRng
 Represents Group Range in a PivotField. More...
 

Enumerations

enum  PivotConditionFormatRuleType { PivotConditionFormatRuleType_None, PivotConditionFormatRuleType_All, PivotConditionFormatRuleType_Row, PivotConditionFormatRuleType_Column }
 Represents PivotTable condition formatting rule type. More...
 
enum  PivotConditionFormatScopeType { PivotConditionFormatScopeType_Data = 0, PivotConditionFormatScopeType_Field = 1, PivotConditionFormatScopeType_Selection = 2 }
 Represents PivotTable condition formatting scope type. More...
 
enum  PivotFieldDataDisplayFormat {
  PivotFieldDataDisplayFormat_Normal = 0, PivotFieldDataDisplayFormat_DifferenceFrom = 1, PivotFieldDataDisplayFormat_PercentageOf = 2, PivotFieldDataDisplayFormat_PercentageDifferenceFrom = 3,
  PivotFieldDataDisplayFormat_RunningTotalIn = 4, PivotFieldDataDisplayFormat_PercentageOfRow = 5, PivotFieldDataDisplayFormat_PercentageOfColumn = 6, PivotFieldDataDisplayFormat_PercentageOfTotal = 7,
  PivotFieldDataDisplayFormat_Index = 8, PivotFieldDataDisplayFormat_PercentageOfParentRowTotal = 9, PivotFieldDataDisplayFormat_PercentageOfParentColumnTotal = 10, PivotFieldDataDisplayFormat_PercentageOfParentTotal = 11,
  PivotFieldDataDisplayFormat_PercentageOfRunningTotalIn = 12, PivotFieldDataDisplayFormat_RankSmallestToLargest = 13, PivotFieldDataDisplayFormat_RankLargestToSmallest = 14
}
 Represents data display format in the PivotTable data field. More...
 
enum  PivotFieldSubtotalType {
  PivotFieldSubtotalType_None = 0, PivotFieldSubtotalType_Automatic = 1, PivotFieldSubtotalType_Sum = 2, PivotFieldSubtotalType_Count = 4,
  PivotFieldSubtotalType_Average = 8, PivotFieldSubtotalType_Max = 0x10, PivotFieldSubtotalType_Min = 0x20, PivotFieldSubtotalType_Product = 0x40,
  PivotFieldSubtotalType_CountNums = 0x80, PivotFieldSubtotalType_Stdev = 0x100, PivotFieldSubtotalType_Stdevp = 0x200, PivotFieldSubtotalType_Var = 0x400,
  PivotFieldSubtotalType_Varp = 0x800
}
 Summary description for PivotFieldSubtotalType. More...
 
enum  PivotFieldType {
  PivotFieldType_Undefined = 0, PivotFieldType_Row = 1, PivotFieldType_Column = 2, PivotFieldType_Page = 4,
  PivotFieldType_Data = 8
}
 Represents PivotTable field type. More...
 
enum  PivotFilterType {
  PivotFilterType_CaptionBeginsWith = 0, PivotFilterType_CaptionBetween = 1, PivotFilterType_CaptionContains = 2, PivotFilterType_CaptionEndsWith = 3,
  PivotFilterType_CaptionEqual = 4, PivotFilterType_CaptionGreaterThan = 5, PivotFilterType_CaptionGreaterThanOrEqual = 6, PivotFilterType_CaptionLessThan = 7,
  PivotFilterType_CaptionLessThanOrEqual = 8, PivotFilterType_CaptionNotBeginsWith = 9, PivotFilterType_CaptionNotBetween = 10, PivotFilterType_CaptionNotContains = 11,
  PivotFilterType_CaptionNotEndsWith = 12, PivotFilterType_CaptionNotEqual = 13, PivotFilterType_Count = 14, PivotFilterType_DateBetween = 15,
  PivotFilterType_DateEqual = 16, PivotFilterType_DateNewerThan = 17, PivotFilterType_DateNewerThanOrEqual = 18, PivotFilterType_DateNotBetween = 19,
  PivotFilterType_DateNotEqual = 20, PivotFilterType_DateOlderThan = 21, PivotFilterType_DateOlderThanOrEqual = 22, PivotFilterType_LastMonth = 23,
  PivotFilterType_LastQuarter = 24, PivotFilterType_LastWeek = 25, PivotFilterType_LastYear = 26, PivotFilterType_M1 = 27,
  PivotFilterType_M2 = 28, PivotFilterType_M3 = 29, PivotFilterType_M4 = 30, PivotFilterType_M5 = 31,
  PivotFilterType_M6 = 32, PivotFilterType_M7 = 33, PivotFilterType_M8 = 34, PivotFilterType_M9 = 35,
  PivotFilterType_M10 = 36, PivotFilterType_M11 = 37, PivotFilterType_M12 = 38, PivotFilterType_NextMonth = 39,
  PivotFilterType_NextQuarter = 40, PivotFilterType_NextWeek = 41, PivotFilterType_NextYear = 42, PivotFilterType_Percent = 43,
  PivotFilterType_Q1 = 44, PivotFilterType_Q2 = 45, PivotFilterType_Q3 = 46, PivotFilterType_Q4 = 47,
  PivotFilterType_Sum = 48, PivotFilterType_ThisMonth = 49, PivotFilterType_ThisQuarter = 50, PivotFilterType_ThisWeek = 51,
  PivotFilterType_ThisYear = 52, PivotFilterType_Today = 53, PivotFilterType_Tomorrow = 54, PivotFilterType_Unknown = 55,
  PivotFilterType_ValueBetween = 56, PivotFilterType_ValueEqual = 57, PivotFilterType_ValueGreaterThan = 58, PivotFilterType_ValueGreaterThanOrEqual = 59,
  PivotFilterType_ValueLessThan = 60, PivotFilterType_ValueLessThanOrEqual = 61, PivotFilterType_ValueNotBetween = 62, PivotFilterType_ValueNotEqual = 63,
  PivotFilterType_YearToDate = 64, PivotFilterType_Yesterday = 65
}
 Represents PivotTable Filter type. More...
 
enum  PivotGroupByType {
  PivotGroupByType_RangeOfValues = 0, PivotGroupByType_Seconds = 1, PivotGroupByType_Minutes = 2, PivotGroupByType_Hours = 3,
  PivotGroupByType_Days = 4, PivotGroupByType_Months = 5, PivotGroupByType_Quarters = 6, PivotGroupByType_Years = 7
}
 Represents PivotTable groupby type. More...
 
enum  PivotItemPosition { PivotItemPosition_Previous, PivotItemPosition_Next, PivotItemPosition_Custom }
 Represents PivotTable base item Next/Previous/All position in the base field . More...
 
enum  PivotMissingItemLimitType { PivotMissingItemLimitType_Automatic = 0, PivotMissingItemLimitType_Max = 1, PivotMissingItemLimitType_None = 2 }
 Represents number of items to retain per field. More...
 
enum  PivotTableAutoFormatType {
  PivotTableAutoFormatType_None, PivotTableAutoFormatType_Classic, PivotTableAutoFormatType_Report1, PivotTableAutoFormatType_Report2,
  PivotTableAutoFormatType_Report3, PivotTableAutoFormatType_Report4, PivotTableAutoFormatType_Report5, PivotTableAutoFormatType_Report6,
  PivotTableAutoFormatType_Report7, PivotTableAutoFormatType_Report8, PivotTableAutoFormatType_Report9, PivotTableAutoFormatType_Report10,
  PivotTableAutoFormatType_Table1, PivotTableAutoFormatType_Table2, PivotTableAutoFormatType_Table3, PivotTableAutoFormatType_Table4,
  PivotTableAutoFormatType_Table5, PivotTableAutoFormatType_Table6, PivotTableAutoFormatType_Table7, PivotTableAutoFormatType_Table8,
  PivotTableAutoFormatType_Table9, PivotTableAutoFormatType_Table10
}
 Represents PivotTable auto format type. More...
 
enum  PivotTableStyleType {
  PivotTableStyleType_None, PivotTableStyleType_PivotTableStyleLight1, PivotTableStyleType_PivotTableStyleLight2, PivotTableStyleType_PivotTableStyleLight3,
  PivotTableStyleType_PivotTableStyleLight4, PivotTableStyleType_PivotTableStyleLight5, PivotTableStyleType_PivotTableStyleLight6, PivotTableStyleType_PivotTableStyleLight7,
  PivotTableStyleType_PivotTableStyleLight8, PivotTableStyleType_PivotTableStyleLight9, PivotTableStyleType_PivotTableStyleLight10, PivotTableStyleType_PivotTableStyleLight11,
  PivotTableStyleType_PivotTableStyleLight12, PivotTableStyleType_PivotTableStyleLight13, PivotTableStyleType_PivotTableStyleLight14, PivotTableStyleType_PivotTableStyleLight15,
  PivotTableStyleType_PivotTableStyleLight16, PivotTableStyleType_PivotTableStyleLight17, PivotTableStyleType_PivotTableStyleLight18, PivotTableStyleType_PivotTableStyleLight19,
  PivotTableStyleType_PivotTableStyleLight20, PivotTableStyleType_PivotTableStyleLight21, PivotTableStyleType_PivotTableStyleLight22, PivotTableStyleType_PivotTableStyleLight23,
  PivotTableStyleType_PivotTableStyleLight24, PivotTableStyleType_PivotTableStyleLight25, PivotTableStyleType_PivotTableStyleLight26, PivotTableStyleType_PivotTableStyleLight27,
  PivotTableStyleType_PivotTableStyleLight28, PivotTableStyleType_PivotTableStyleMedium1, PivotTableStyleType_PivotTableStyleMedium2, PivotTableStyleType_PivotTableStyleMedium3,
  PivotTableStyleType_PivotTableStyleMedium4, PivotTableStyleType_PivotTableStyleMedium5, PivotTableStyleType_PivotTableStyleMedium6, PivotTableStyleType_PivotTableStyleMedium7,
  PivotTableStyleType_PivotTableStyleMedium8, PivotTableStyleType_PivotTableStyleMedium9, PivotTableStyleType_PivotTableStyleMedium10, PivotTableStyleType_PivotTableStyleMedium11,
  PivotTableStyleType_PivotTableStyleMedium12, PivotTableStyleType_PivotTableStyleMedium13, PivotTableStyleType_PivotTableStyleMedium14, PivotTableStyleType_PivotTableStyleMedium15,
  PivotTableStyleType_PivotTableStyleMedium16, PivotTableStyleType_PivotTableStyleMedium17, PivotTableStyleType_PivotTableStyleMedium18, PivotTableStyleType_PivotTableStyleMedium19,
  PivotTableStyleType_PivotTableStyleMedium20, PivotTableStyleType_PivotTableStyleMedium21, PivotTableStyleType_PivotTableStyleMedium22, PivotTableStyleType_PivotTableStyleMedium23,
  PivotTableStyleType_PivotTableStyleMedium24, PivotTableStyleType_PivotTableStyleMedium25, PivotTableStyleType_PivotTableStyleMedium26, PivotTableStyleType_PivotTableStyleMedium27,
  PivotTableStyleType_PivotTableStyleMedium28, PivotTableStyleType_PivotTableStyleDark1, PivotTableStyleType_PivotTableStyleDark2, PivotTableStyleType_PivotTableStyleDark3,
  PivotTableStyleType_PivotTableStyleDark4, PivotTableStyleType_PivotTableStyleDark5, PivotTableStyleType_PivotTableStyleDark6, PivotTableStyleType_PivotTableStyleDark7,
  PivotTableStyleType_PivotTableStyleDark8, PivotTableStyleType_PivotTableStyleDark9, PivotTableStyleType_PivotTableStyleDark10, PivotTableStyleType_PivotTableStyleDark11,
  PivotTableStyleType_PivotTableStyleDark12, PivotTableStyleType_PivotTableStyleDark13, PivotTableStyleType_PivotTableStyleDark14, PivotTableStyleType_PivotTableStyleDark15,
  PivotTableStyleType_PivotTableStyleDark16, PivotTableStyleType_PivotTableStyleDark17, PivotTableStyleType_PivotTableStyleDark18, PivotTableStyleType_PivotTableStyleDark19,
  PivotTableStyleType_PivotTableStyleDark20, PivotTableStyleType_PivotTableStyleDark21, PivotTableStyleType_PivotTableStyleDark22, PivotTableStyleType_PivotTableStyleDark23,
  PivotTableStyleType_PivotTableStyleDark24, PivotTableStyleType_PivotTableStyleDark25, PivotTableStyleType_PivotTableStyleDark26, PivotTableStyleType_PivotTableStyleDark27,
  PivotTableStyleType_PivotTableStyleDark28, PivotTableStyleType_Custom
}
 Represents the pivot table style type. More...
 

Enumeration Type Documentation

§ PivotConditionFormatRuleType

Represents PivotTable condition formatting rule type.

Enumerator
PivotConditionFormatRuleType_None 

Indicates that Top N conditional formatting is not evaluated

PivotConditionFormatRuleType_All 

Indicates that Top N conditional formatting is evaluated across the entire scope range.

PivotConditionFormatRuleType_Row 

Indicates that Top N conditional formatting is evaluated for each row.

PivotConditionFormatRuleType_Column 

Indicates that Top N conditional formatting is evaluated for each column.

§ PivotConditionFormatScopeType

Represents PivotTable condition formatting scope type.

Enumerator
PivotConditionFormatScopeType_Data 

Indicates that conditional formatting is applied to the selected data fields.

PivotConditionFormatScopeType_Field 

Indicates that conditional formatting is applied to the selected PivotTable field intersections.

PivotConditionFormatScopeType_Selection 

Indicates that conditional formatting is applied to the selected cells.

§ PivotFieldDataDisplayFormat

Represents data display format in the PivotTable data field.

Enumerator
PivotFieldDataDisplayFormat_Normal 

Represents normal dispaly format.

PivotFieldDataDisplayFormat_DifferenceFrom 

Represents difference from dispaly format.

PivotFieldDataDisplayFormat_PercentageOf 

Represents percentage of dispaly format.

PivotFieldDataDisplayFormat_PercentageDifferenceFrom 

Represents percentage difference from display format.

PivotFieldDataDisplayFormat_RunningTotalIn 

Represents running total in dispaly format.

PivotFieldDataDisplayFormat_PercentageOfRow 

Represents percentage of row dispaly format.

PivotFieldDataDisplayFormat_PercentageOfColumn 

Represents percentage of column dispaly format.

PivotFieldDataDisplayFormat_PercentageOfTotal 

Represents percentage of total dispaly format.

PivotFieldDataDisplayFormat_Index 

Represents index dispaly format.

PivotFieldDataDisplayFormat_PercentageOfParentRowTotal 

Represents percentage of parent row total dispaly format.

PivotFieldDataDisplayFormat_PercentageOfParentColumnTotal 

Represents percentage of parent column total dispaly format.

PivotFieldDataDisplayFormat_PercentageOfParentTotal 

Represents percentage of parent total dispaly format.

PivotFieldDataDisplayFormat_PercentageOfRunningTotalIn 

Represents percentage of running total in dispaly format.

PivotFieldDataDisplayFormat_RankSmallestToLargest 

Represents smallest to largest dispaly format.

PivotFieldDataDisplayFormat_RankLargestToSmallest 

Represents largest to smallest dispaly format.

§ PivotFieldSubtotalType

Summary description for PivotFieldSubtotalType.

Enumerator
PivotFieldSubtotalType_None 

Represents None subtotal type.

PivotFieldSubtotalType_Automatic 

Represents Automatic subtotal type.

PivotFieldSubtotalType_Sum 

Represents Sum subtotal type.

PivotFieldSubtotalType_Count 

Represents Count subtotal type.

PivotFieldSubtotalType_Average 

Represents Average subtotal type.

PivotFieldSubtotalType_Max 

Represents Max subtotal type.

PivotFieldSubtotalType_Min 

Represents Min subtotal type.

PivotFieldSubtotalType_Product 

Represents Product subtotal type.

PivotFieldSubtotalType_CountNums 

Represents Count Nums subtotal type.

PivotFieldSubtotalType_Stdev 

Represents Stdev subtotal type.

PivotFieldSubtotalType_Stdevp 

Represents Stdevp subtotal type.

PivotFieldSubtotalType_Var 

Represents Var subtotal type.

PivotFieldSubtotalType_Varp 

Represents Varp subtotal type.

§ PivotFieldType

Represents PivotTable field type.

Enumerator
PivotFieldType_Undefined 

Presents base pivot field type.

PivotFieldType_Row 

Presents row pivot field type.

PivotFieldType_Column 

Presents column pivot field type.

PivotFieldType_Page 

Presents page pivot field type.

PivotFieldType_Data 

Presents data pivot field type.

§ PivotFilterType

Represents PivotTable Filter type.

Enumerator
PivotFilterType_CaptionBeginsWith 

Indicates the "begins with" filter for field captions.

PivotFilterType_CaptionBetween 

Indicates the "is between" filter for field captions.

PivotFilterType_CaptionContains 

Indicates the "contains" filter for field captions.

PivotFilterType_CaptionEndsWith 

Indicates the "ends with" filter for field captions.

PivotFilterType_CaptionEqual 

Indicates the "equal" filter for field captions.

PivotFilterType_CaptionGreaterThan 

Indicates the "is greater than" filter for field captions.

PivotFilterType_CaptionGreaterThanOrEqual 

Indicates the "is greater than or equal to" filter for field captions.

PivotFilterType_CaptionLessThan 

Indicates the "is less than" filter for field captions.

PivotFilterType_CaptionLessThanOrEqual 

Indicates the "is less than or equal to" filter for field captions.

PivotFilterType_CaptionNotBeginsWith 

Indicates the "does not begin with" filter for field captions.

PivotFilterType_CaptionNotBetween 

Indicates the "is not between" filter for field captions.

PivotFilterType_CaptionNotContains 

Indicates the "does not contain" filter for field captions.

PivotFilterType_CaptionNotEndsWith 

Indicates the "does not end with" filter for field captions.

PivotFilterType_CaptionNotEqual 

Indicates the "not equal" filter for field captions.

PivotFilterType_Count 

Indicates the "count" filter.

PivotFilterType_DateBetween 

Indicates the "between" filter for date values.

PivotFilterType_DateEqual 

Indicates the "equals" filter for date values.

PivotFilterType_DateNewerThan 

Indicates the "newer than" filter for date values.

PivotFilterType_DateNewerThanOrEqual 

Indicates the "newer than or equal to" filter for date values.

PivotFilterType_DateNotBetween 

Indicates the "not between" filter for date values.

PivotFilterType_DateNotEqual 

Indicates the "does not equal" filter for date values.

PivotFilterType_DateOlderThan 

Indicates the "older than" filter for date values.

PivotFilterType_DateOlderThanOrEqual 

Indicates the "older than or equal to" filter for date values.

PivotFilterType_LastMonth 

Indicates the "last month" filter for date values.

PivotFilterType_LastQuarter 

Indicates the "last quarter" filter for date values.

PivotFilterType_LastWeek 

Indicates the "last week" filter for date values.

PivotFilterType_LastYear 

Indicates the "last year" filter for date values.

PivotFilterType_M1 

Indicates the "January" filter for date values.

PivotFilterType_M2 

Indicates the "February" filter for date values.

PivotFilterType_M3 

Indicates the "March" filter for date values.

PivotFilterType_M4 

Indicates the "April" filter for date values.

PivotFilterType_M5 

Indicates the "May" filter for date values.

PivotFilterType_M6 

Indicates the "June" filter for date values.

PivotFilterType_M7 

Indicates the "July" filter for date values.

PivotFilterType_M8 

Indicates the "August" filter for date values.

PivotFilterType_M9 

Indicates the "September" filter for date values.

PivotFilterType_M10 

Indicates the "October" filter for date values.

PivotFilterType_M11 

Indicates the "November" filter for date values.

PivotFilterType_M12 

Indicates the "December" filter for date values.

PivotFilterType_NextMonth 

Indicates the "next month" filter for date values.

PivotFilterType_NextQuarter 

Indicates the "next quarter" for date values.

PivotFilterType_NextWeek 

Indicates the "next week" for date values.

PivotFilterType_NextYear 

Indicates the "next year" filter for date values.

PivotFilterType_Percent 

Indicates the "percent" filter for numeric values.

PivotFilterType_Q1 

Indicates the "first quarter" filter for date values.

PivotFilterType_Q2 

Indicates the "second quarter" filter for date values.

PivotFilterType_Q3 

Indicates the "third quarter" filter for date values.

PivotFilterType_Q4 

Indicates the "fourth quarter" filter for date values.

PivotFilterType_Sum 

Indicates the "sum" filter for numeric values.

PivotFilterType_ThisMonth 

Indicates the "this month" filter for date values.

PivotFilterType_ThisQuarter 

Indicates the "this quarter" filter for date values.

PivotFilterType_ThisWeek 

Indicates the "this week" filter for date values.

PivotFilterType_ThisYear 

Indicate the "this year" filter for date values.

PivotFilterType_Today 

Indicates the "today" filter for date values.

PivotFilterType_Tomorrow 

Indicates the "tomorrow" filter for date values.

PivotFilterType_Unknown 

Indicates the PivotTable filter is unknown to the application.

PivotFilterType_ValueBetween 

Indicates the "Value between" filter for text and numeric values.

PivotFilterType_ValueEqual 

Indicates the "value equal" filter for text and numeric values.

PivotFilterType_ValueGreaterThan 

Indicates the "value greater than" filter for text and numeric values.

PivotFilterType_ValueGreaterThanOrEqual 

Indicates the "value greater than or equal to" filter for text and numeric values.

PivotFilterType_ValueLessThan 

Indicates the "value less than" filter for text and numeric values.

PivotFilterType_ValueLessThanOrEqual 

Indicates the "value less than or equal to" filter for text and numeric values.

PivotFilterType_ValueNotBetween 

Indicates the "value not between" filter for text and numeric values.

PivotFilterType_ValueNotEqual 

Indicates the "value not equal" filter for text and numeric values.

PivotFilterType_YearToDate 

Indicates the "year-to-date" filter for date values.

PivotFilterType_Yesterday 

Indicates the "yesterday" filter for date values.

§ PivotGroupByType

Represents PivotTable groupby type.

Enumerator
PivotGroupByType_RangeOfValues 

Presents rangeofvalues groupby type.

PivotGroupByType_Seconds 

Presents Seconds groupby type.

PivotGroupByType_Minutes 

Presents Minutes groupby type.

PivotGroupByType_Hours 

Presents Hours groupby type.

PivotGroupByType_Days 

Presents Days groupby type.

PivotGroupByType_Months 

Presents Months groupby type.

PivotGroupByType_Quarters 

Presents Quarters groupby type.

PivotGroupByType_Years 

Presents Years groupby type.

§ PivotItemPosition

Represents PivotTable base item Next/Previous/All position in the base field .

Enumerator
PivotItemPosition_Previous 

Represents the previous pivot item in the PivotField.

PivotItemPosition_Next 

Represents the next pivot item in the PivotField.

PivotItemPosition_Custom 

Represents a pivot item index, as specified by Pivot Items, that specifies a pivot item in the PivotField.

only read

§ PivotMissingItemLimitType

Represents number of items to retain per field.

Enumerator
PivotMissingItemLimitType_Automatic 

The default number of unique items per PivotField allowed.

PivotMissingItemLimitType_Max 

The maximum number of unique items per PivotField allowed (>32,500).

PivotMissingItemLimitType_None 

No unique items per PivotField allowed.

§ PivotTableAutoFormatType

Represents PivotTable auto format type.

Enumerator
PivotTableAutoFormatType_None 

Represents None format type.

PivotTableAutoFormatType_Classic 

Represents Classic auto format type.

PivotTableAutoFormatType_Report1 

Represents Report1 format type.

PivotTableAutoFormatType_Report2 

Represents Report2 format type.

PivotTableAutoFormatType_Report3 

Represents Report3 format type.

PivotTableAutoFormatType_Report4 

Represents Report4 format type.

PivotTableAutoFormatType_Report5 

Represents Report5 format type.

PivotTableAutoFormatType_Report6 

Represents Report6 format type.

PivotTableAutoFormatType_Report7 

Represents Report7 format type.

PivotTableAutoFormatType_Report8 

Represents Report8 format type.

PivotTableAutoFormatType_Report9 

Represents Report9 format type.

PivotTableAutoFormatType_Report10 

Represents Report10 format type.

PivotTableAutoFormatType_Table1 

Represents Table1 format type.

PivotTableAutoFormatType_Table2 

Represents Table2 format type.

PivotTableAutoFormatType_Table3 

Represents Table3 format type.

PivotTableAutoFormatType_Table4 

Represents Table4 format type.

PivotTableAutoFormatType_Table5 

Represents Table5 format type.

PivotTableAutoFormatType_Table6 

Represents Table6 format type.

PivotTableAutoFormatType_Table7 

Represents Table7 format type.

PivotTableAutoFormatType_Table8 

Represents Table8 format type.

PivotTableAutoFormatType_Table9 

Represents Table9 format type.

PivotTableAutoFormatType_Table10 

Represents Table10 format type.

§ PivotTableStyleType

Represents the pivot table style type.

Enumerator
PivotTableStyleType_None 
PivotTableStyleType_PivotTableStyleLight1 
PivotTableStyleType_PivotTableStyleLight2 
PivotTableStyleType_PivotTableStyleLight3 
PivotTableStyleType_PivotTableStyleLight4 
PivotTableStyleType_PivotTableStyleLight5 
PivotTableStyleType_PivotTableStyleLight6 
PivotTableStyleType_PivotTableStyleLight7 
PivotTableStyleType_PivotTableStyleLight8 
PivotTableStyleType_PivotTableStyleLight9 
PivotTableStyleType_PivotTableStyleLight10 
PivotTableStyleType_PivotTableStyleLight11 
PivotTableStyleType_PivotTableStyleLight12 
PivotTableStyleType_PivotTableStyleLight13 
PivotTableStyleType_PivotTableStyleLight14 
PivotTableStyleType_PivotTableStyleLight15 
PivotTableStyleType_PivotTableStyleLight16 
PivotTableStyleType_PivotTableStyleLight17 
PivotTableStyleType_PivotTableStyleLight18 
PivotTableStyleType_PivotTableStyleLight19 
PivotTableStyleType_PivotTableStyleLight20 
PivotTableStyleType_PivotTableStyleLight21 
PivotTableStyleType_PivotTableStyleLight22 
PivotTableStyleType_PivotTableStyleLight23 
PivotTableStyleType_PivotTableStyleLight24 
PivotTableStyleType_PivotTableStyleLight25 
PivotTableStyleType_PivotTableStyleLight26 
PivotTableStyleType_PivotTableStyleLight27 
PivotTableStyleType_PivotTableStyleLight28 
PivotTableStyleType_PivotTableStyleMedium1 
PivotTableStyleType_PivotTableStyleMedium2 
PivotTableStyleType_PivotTableStyleMedium3 
PivotTableStyleType_PivotTableStyleMedium4 
PivotTableStyleType_PivotTableStyleMedium5 
PivotTableStyleType_PivotTableStyleMedium6 
PivotTableStyleType_PivotTableStyleMedium7 
PivotTableStyleType_PivotTableStyleMedium8 
PivotTableStyleType_PivotTableStyleMedium9 
PivotTableStyleType_PivotTableStyleMedium10 
PivotTableStyleType_PivotTableStyleMedium11 
PivotTableStyleType_PivotTableStyleMedium12 
PivotTableStyleType_PivotTableStyleMedium13 
PivotTableStyleType_PivotTableStyleMedium14 
PivotTableStyleType_PivotTableStyleMedium15 
PivotTableStyleType_PivotTableStyleMedium16 
PivotTableStyleType_PivotTableStyleMedium17 
PivotTableStyleType_PivotTableStyleMedium18 
PivotTableStyleType_PivotTableStyleMedium19 
PivotTableStyleType_PivotTableStyleMedium20 
PivotTableStyleType_PivotTableStyleMedium21 
PivotTableStyleType_PivotTableStyleMedium22 
PivotTableStyleType_PivotTableStyleMedium23 
PivotTableStyleType_PivotTableStyleMedium24 
PivotTableStyleType_PivotTableStyleMedium25 
PivotTableStyleType_PivotTableStyleMedium26 
PivotTableStyleType_PivotTableStyleMedium27 
PivotTableStyleType_PivotTableStyleMedium28 
PivotTableStyleType_PivotTableStyleDark1 
PivotTableStyleType_PivotTableStyleDark2 
PivotTableStyleType_PivotTableStyleDark3 
PivotTableStyleType_PivotTableStyleDark4 
PivotTableStyleType_PivotTableStyleDark5 
PivotTableStyleType_PivotTableStyleDark6 
PivotTableStyleType_PivotTableStyleDark7 
PivotTableStyleType_PivotTableStyleDark8 
PivotTableStyleType_PivotTableStyleDark9 
PivotTableStyleType_PivotTableStyleDark10 
PivotTableStyleType_PivotTableStyleDark11 
PivotTableStyleType_PivotTableStyleDark12 
PivotTableStyleType_PivotTableStyleDark13 
PivotTableStyleType_PivotTableStyleDark14 
PivotTableStyleType_PivotTableStyleDark15 
PivotTableStyleType_PivotTableStyleDark16 
PivotTableStyleType_PivotTableStyleDark17 
PivotTableStyleType_PivotTableStyleDark18 
PivotTableStyleType_PivotTableStyleDark19 
PivotTableStyleType_PivotTableStyleDark20 
PivotTableStyleType_PivotTableStyleDark21 
PivotTableStyleType_PivotTableStyleDark22 
PivotTableStyleType_PivotTableStyleDark23 
PivotTableStyleType_PivotTableStyleDark24 
PivotTableStyleType_PivotTableStyleDark25 
PivotTableStyleType_PivotTableStyleDark26 
PivotTableStyleType_PivotTableStyleDark27 
PivotTableStyleType_PivotTableStyleDark28 
PivotTableStyleType_Custom