Class PivotTable


  • public class PivotTable
    extends System.Object
    This class contains the constants for the pivot tables.
    • Field Detail

      • AREA_NONE

        public const int AREA_NONE
        A constant indicating that the pivot table field is not added to any area. Embedded value is 0.
        See Also:
        Constant Values
      • AREA_ROW_LABELS

        public const int AREA_ROW_LABELS
        A constant indicating that the pivot table field is added to row labels area. Embedded value is 1.
        See Also:
        Constant Values
      • AREA_COLUMN_LABELS

        public const int AREA_COLUMN_LABELS
        A constant indicating that the pivot table field is added to column labels area. Embedded value is 2.
        See Also:
        Constant Values
      • AREA_REPORT_FILTER

        public const int AREA_REPORT_FILTER
        A constant indicating that the pivot table field is added to report filter area. Embedded value is 4.
        See Also:
        Constant Values
      • SORT_A_TO_Z

        public const int SORT_A_TO_Z
        Ascending order from A to Z. Embedded value is 0.
        See Also:
        Constant Values
      • SORT_IN_DATA_SOURCE_ORDER

        public const int SORT_IN_DATA_SOURCE_ORDER
        Sort order according to data source order. Embedded value is 0.
        See Also:
        Constant Values
      • SORT_Z_TO_A

        public const int SORT_Z_TO_A
        Descending order from Z to A. Embedded value is 2.
        See Also:
        Constant Values
      • PIVOT_STYLE_NONE

        public const System.String PIVOT_STYLE_NONE
        A constant indicating that no style is applied for the pivot table. Embedded value is "None".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_1

        public const System.String PIVOT_STYLE_LIGHT_1
        Pivot style Light 1 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight1".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_2

        public const System.String PIVOT_STYLE_LIGHT_2
        Pivot style Light 2 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight2".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_3

        public const System.String PIVOT_STYLE_LIGHT_3
        Pivot style Light 3 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight3".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_4

        public const System.String PIVOT_STYLE_LIGHT_4
        Pivot style Light 4 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight4".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_5

        public const System.String PIVOT_STYLE_LIGHT_5
        Pivot style Light 5 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight5".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_6

        public const System.String PIVOT_STYLE_LIGHT_6
        Pivot style Light 6 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight6".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_7

        public const System.String PIVOT_STYLE_LIGHT_7
        Pivot style Light 7 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight7".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_8

        public const System.String PIVOT_STYLE_LIGHT_8
        Pivot style Light 8 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight8".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_9

        public const System.String PIVOT_STYLE_LIGHT_9
        Pivot style Light 9 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight9".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_10

        public const System.String PIVOT_STYLE_LIGHT_10
        Pivot style Light 10 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight10".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_11

        public const System.String PIVOT_STYLE_LIGHT_11
        Pivot style Light 11 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight11".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_12

        public const System.String PIVOT_STYLE_LIGHT_12
        Pivot style Light 12 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight12".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_13

        public const System.String PIVOT_STYLE_LIGHT_13
        Pivot style Light 13 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight13".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_14

        public const System.String PIVOT_STYLE_LIGHT_14
        Pivot style Light 14 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight14".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_15

        public const System.String PIVOT_STYLE_LIGHT_15
        Pivot style Light 15 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight15".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_16

        public const System.String PIVOT_STYLE_LIGHT_16
        Pivot style Light 16 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight16".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_17

        public const System.String PIVOT_STYLE_LIGHT_17
        Pivot style Light 17 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight17".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_18

        public const System.String PIVOT_STYLE_LIGHT_18
        Pivot style Light 18 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight18".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_19

        public const System.String PIVOT_STYLE_LIGHT_19
        Pivot style Light 19 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight19".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_20

        public const System.String PIVOT_STYLE_LIGHT_20
        Pivot style Light 20 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight20".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_21

        public const System.String PIVOT_STYLE_LIGHT_21
        Pivot style Light 21 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight21".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_22

        public const System.String PIVOT_STYLE_LIGHT_22
        Pivot style Light 22 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight22".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_23

        public const System.String PIVOT_STYLE_LIGHT_23
        Pivot style Light 23 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight23".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_24

        public const System.String PIVOT_STYLE_LIGHT_24
        Pivot style Light 24 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight24".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_25

        public const System.String PIVOT_STYLE_LIGHT_25
        Pivot style Light 25 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight25".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_26

        public const System.String PIVOT_STYLE_LIGHT_26
        Pivot style Light 26 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight26".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_27

        public const System.String PIVOT_STYLE_LIGHT_27
        Pivot style Light 27 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight27".
        See Also:
        Constant Values
      • PIVOT_STYLE_LIGHT_28

        public const System.String PIVOT_STYLE_LIGHT_28
        Pivot style Light 28 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleLight28".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_1

        public const System.String PIVOT_STYLE_MEDIUM_1
        Pivot style Medium 1 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium1".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_2

        public const System.String PIVOT_STYLE_MEDIUM_2
        Pivot style Medium 2 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium2".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_3

        public const System.String PIVOT_STYLE_MEDIUM_3
        Pivot style Medium 3 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium3".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_4

        public const System.String PIVOT_STYLE_MEDIUM_4
        Pivot style Medium 4 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium4".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_5

        public const System.String PIVOT_STYLE_MEDIUM_5
        Pivot style Medium 5 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium5".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_6

        public const System.String PIVOT_STYLE_MEDIUM_6
        Pivot style Medium 6 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium6".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_7

        public const System.String PIVOT_STYLE_MEDIUM_7
        Pivot style Medium 7 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium7".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_8

        public const System.String PIVOT_STYLE_MEDIUM_8
        Pivot style Medium 8 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium8".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_9

        public const System.String PIVOT_STYLE_MEDIUM_9
        Pivot style Medium 9 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium9".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_10

        public const System.String PIVOT_STYLE_MEDIUM_10
        Pivot style Medium 10 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium10".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_11

        public const System.String PIVOT_STYLE_MEDIUM_11
        Pivot style Medium 11 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium11".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_12

        public const System.String PIVOT_STYLE_MEDIUM_12
        Pivot style Medium 12 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium12".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_13

        public const System.String PIVOT_STYLE_MEDIUM_13
        Pivot style Medium 13 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium13".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_14

        public const System.String PIVOT_STYLE_MEDIUM_14
        Pivot style Medium 14 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium14".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_15

        public const System.String PIVOT_STYLE_MEDIUM_15
        Pivot style Medium 15 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium15".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_16

        public const System.String PIVOT_STYLE_MEDIUM_16
        Pivot style Medium 16 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium16".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_17

        public const System.String PIVOT_STYLE_MEDIUM_17
        Pivot style Medium 17 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium17".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_18

        public const System.String PIVOT_STYLE_MEDIUM_18
        Pivot style Medium 18 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium18".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_19

        public const System.String PIVOT_STYLE_MEDIUM_19
        Pivot style Medium 19 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium19".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_20

        public const System.String PIVOT_STYLE_MEDIUM_20
        Pivot style Medium 20 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium20".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_21

        public const System.String PIVOT_STYLE_MEDIUM_21
        Pivot style Medium 21 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium21".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_22

        public const System.String PIVOT_STYLE_MEDIUM_22
        Pivot style Medium 22 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium22".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_23

        public const System.String PIVOT_STYLE_MEDIUM_23
        Pivot style Medium 23 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium23".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_24

        public const System.String PIVOT_STYLE_MEDIUM_24
        Pivot style Medium 24 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium24".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_25

        public const System.String PIVOT_STYLE_MEDIUM_25
        Pivot style Medium 25 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium25".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_26

        public const System.String PIVOT_STYLE_MEDIUM_26
        Pivot style Medium 26 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium26".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_27

        public const System.String PIVOT_STYLE_MEDIUM_27
        Pivot style Medium 27 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium27".
        See Also:
        Constant Values
      • PIVOT_STYLE_MEDIUM_28

        public const System.String PIVOT_STYLE_MEDIUM_28
        Pivot style Medium 28 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleMedium28".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_1

        public const System.String PIVOT_STYLE_DARK_1
        Pivot style Dark 1 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark1".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_2

        public const System.String PIVOT_STYLE_DARK_2
        Pivot style Dark 2 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark2".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_3

        public const System.String PIVOT_STYLE_DARK_3
        Pivot style Dark 3 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark3".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_4

        public const System.String PIVOT_STYLE_DARK_4
        Pivot style Dark 4 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark4".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_5

        public const System.String PIVOT_STYLE_DARK_5
        Pivot style Dark 5 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark5".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_6

        public const System.String PIVOT_STYLE_DARK_6
        Pivot style Dark 6 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark6".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_7

        public const System.String PIVOT_STYLE_DARK_7
        Pivot style Dark 7 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark7".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_8

        public const System.String PIVOT_STYLE_DARK_8
        Pivot style Dark 8 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark8".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_9

        public const System.String PIVOT_STYLE_DARK_9
        Pivot style Dark 9 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark91".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_10

        public const System.String PIVOT_STYLE_DARK_10
        Pivot style Dark 10 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark10".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_11

        public const System.String PIVOT_STYLE_DARK_11
        Pivot style Dark 11 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark11".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_12

        public const System.String PIVOT_STYLE_DARK_12
        Pivot style Dark 12 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark12".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_13

        public const System.String PIVOT_STYLE_DARK_13
        Pivot style Dark 13 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark13".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_14

        public const System.String PIVOT_STYLE_DARK_14
        Pivot style Dark 14 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark14".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_15

        public const System.String PIVOT_STYLE_DARK_15
        Pivot style Dark 15 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark15".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_16

        public const System.String PIVOT_STYLE_DARK_16
        Pivot style Dark 16 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark16".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_17

        public const System.String PIVOT_STYLE_DARK_17
        Pivot style Dark 17 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark17".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_18

        public const System.String PIVOT_STYLE_DARK_18
        Pivot style Dark 18 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark18".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_19

        public const System.String PIVOT_STYLE_DARK_19
        Pivot style Dark 19 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark19".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_20

        public const System.String PIVOT_STYLE_DARK_20
        Pivot style Dark 20 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark20".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_21

        public const System.String PIVOT_STYLE_DARK_21
        Pivot style Dark 21 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark21".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_22

        public const System.String PIVOT_STYLE_DARK_22
        Pivot style Dark 22 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark22".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_23

        public const System.String PIVOT_STYLE_DARK_23
        Pivot style Dark 23 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark23".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_24

        public const System.String PIVOT_STYLE_DARK_24
        Pivot style Dark 24 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark24".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_25

        public const System.String PIVOT_STYLE_DARK_25
        Pivot style Dark 25 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark25".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_26

        public const System.String PIVOT_STYLE_DARK_26
        Pivot style Dark 26 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark26".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_27

        public const System.String PIVOT_STYLE_DARK_27
        Pivot style Dark 27 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark27".
        See Also:
        Constant Values
      • PIVOT_STYLE_DARK_28

        public const System.String PIVOT_STYLE_DARK_28
        Pivot style Dark 28 for a pivot table. Available only for Office 2007 or later. Embedded value is "PivotStyleDark28".
        See Also:
        Constant Values
      • AUTOFORMAT_REPORT_1

        public const System.String AUTOFORMAT_REPORT_1
        Pivot style (Autoformat) Report 1 for a pivot table. Available only for Office 97-2003. Embedded value is "Report1".
        See Also:
        Constant Values
      • AUTOFORMAT_REPORT_2

        public const System.String AUTOFORMAT_REPORT_2
        Pivot style (Autoformat) Report 2 for a pivot table. Available only for Office 97-2003. Embedded value is "Report2".
        See Also:
        Constant Values
      • AUTOFORMAT_REPORT_3

        public const System.String AUTOFORMAT_REPORT_3
        Pivot style (Autoformat) Report 3 for a pivot table. Available only for Office 97-2003. Embedded value is "Report3".
        See Also:
        Constant Values
      • AUTOFORMAT_REPORT_4

        public const System.String AUTOFORMAT_REPORT_4
        Pivot style (Autoformat) Report 4 for a pivot table. Available only for Office 97-2003. Embedded value is "Report4".
        See Also:
        Constant Values
      • AUTOFORMAT_REPORT_5

        public const System.String AUTOFORMAT_REPORT_5
        Pivot style (Autoformat) Report 5 for a pivot table. Available only for Office 97-2003. Embedded value is "Report5".
        See Also:
        Constant Values
      • AUTOFORMAT_REPORT_6

        public const System.String AUTOFORMAT_REPORT_6
        Pivot style (Autoformat) Report 6 for a pivot table. Available only for Office 97-2003. Embedded value is "Report6".
        See Also:
        Constant Values
      • AUTOFORMAT_REPORT_7

        public const System.String AUTOFORMAT_REPORT_7
        Pivot style (Autoformat) Report 7 for a pivot table. Available only for Office 97-2003. Embedded value is "Report7".
        See Also:
        Constant Values
      • AUTOFORMAT_REPORT_8

        public const System.String AUTOFORMAT_REPORT_8
        Pivot style (Autoformat) Report 8 for a pivot table. Available only for Office 97-2003. Embedded value is "Report8".
        See Also:
        Constant Values
      • AUTOFORMAT_REPORT_9

        public const System.String AUTOFORMAT_REPORT_9
        Pivot style (Autoformat) Report 9 for a pivot table. Available only for Office 97-2003. Embedded value is "Report9".
        See Also:
        Constant Values
      • AUTOFORMAT_REPORT_10

        public const System.String AUTOFORMAT_REPORT_10
        Pivot style (Autoformat) Report 10 for a pivot table. Available only for Office 97-2003. Embedded value is "Report10".
        See Also:
        Constant Values
      • AUTOFORMAT_TABLE_1

        public const System.String AUTOFORMAT_TABLE_1
        Pivot style (Autoformat) Table 1 for a pivot table. Available only for Office 97-2003. Embedded value is "Table1".
        See Also:
        Constant Values
      • AUTOFORMAT_TABLE_2

        public const System.String AUTOFORMAT_TABLE_2
        Pivot style (Autoformat) Table 2 for a pivot table. Available only for Office 97-2003. Embedded value is "Table2".
        See Also:
        Constant Values
      • AUTOFORMAT_TABLE_3

        public const System.String AUTOFORMAT_TABLE_3
        Pivot style (Autoformat) Table 3 for a pivot table. Available only for Office 97-2003. Embedded value is "Table3".
        See Also:
        Constant Values
      • AUTOFORMAT_TABLE_4

        public const System.String AUTOFORMAT_TABLE_4
        Pivot style (Autoformat) Table 4 for a pivot table. Available only for Office 97-2003. Embedded value is "Table4".
        See Also:
        Constant Values
      • AUTOFORMAT_TABLE_5

        public const System.String AUTOFORMAT_TABLE_5
        Pivot style (Autoformat) Table 5 for a pivot table. Available only for Office 97-2003. Embedded value is "Table5".
        See Also:
        Constant Values
      • AUTOFORMAT_TABLE_6

        public const System.String AUTOFORMAT_TABLE_6
        Pivot style (Autoformat) Table 6 for a pivot table. Available only for Office 97-2003. Embedded value is "Table6".
        See Also:
        Constant Values
      • AUTOFORMAT_TABLE_7

        public const System.String AUTOFORMAT_TABLE_7
        Pivot style (Autoformat) Table 7 for a pivot table. Available only for Office 97-2003. Embedded value is "Table7".
        See Also:
        Constant Values
      • AUTOFORMAT_TABLE_8

        public const System.String AUTOFORMAT_TABLE_8
        Pivot style (Autoformat) Table 8 for a pivot table. Available only for Office 97-2003. Embedded value is "Table8".
        See Also:
        Constant Values
      • AUTOFORMAT_TABLE_9

        public const System.String AUTOFORMAT_TABLE_9
        Pivot style (Autoformat) Table 9 for a pivot table. Available only for Office 97-2003. Embedded value is "Table9".
        See Also:
        Constant Values
      • AUTOFORMAT_TABLE_10

        public const System.String AUTOFORMAT_TABLE_10
        Pivot style (Autoformat) Table 10 for a pivot table. Available only for Office 97-2003. Embedded value is "Table10".
        See Also:
        Constant Values
      • AUTOFORMAT_PIVOTTABLE_CLASIC

        public const System.String AUTOFORMAT_PIVOTTABLE_CLASIC
        Pivot style (Autoformat) Pivot Table Clasic for a pivot table. Available only for Office 97-2003. Embedded value is "PivotTableClasic".
        See Also:
        Constant Values
      • AUTOFORMAT_NONE

        public const System.String AUTOFORMAT_NONE
        A constant indicating that no autoformat is applied for the pivot table. Embedded value is "None".
        See Also:
        Constant Values
      • SUM_VALUES_FIELD

        public const System.String SUM_VALUES_FIELD
        A constant indicating the summarization special field. It must be added on row or column labels when more than two fields are present on values area. Embedded value is "#SUM_VALUES#".
        See Also:
        Constant Values
      • SUBTOTAL_NONE

        public const int SUBTOTAL_NONE
        A constant indicating that no subtotal is applied for a pivot table field. Embedded value is 0.
        See Also:
        Constant Values
      • SUBTOTAL_AUTOMATIC

        public const int SUBTOTAL_AUTOMATIC
        Automatic subtotal for a pivot table field. Embedded value is 1.
        See Also:
        Constant Values
      • SUBTOTAL_SUM

        public const int SUBTOTAL_SUM
        Sum subtotal for a pivot table field. Embedded value is 2.
        See Also:
        Constant Values
      • SUBTOTAL_COUNTA

        public const int SUBTOTAL_COUNTA
        CountA subtotal for a pivot table field. Embedded value is 3.
        See Also:
        Constant Values
      • SUBTOTAL_AVERAGE

        public const int SUBTOTAL_AVERAGE
        Average subtotal for a pivot table field. Embedded value is 4.
        See Also:
        Constant Values
      • SUBTOTAL_MAX

        public const int SUBTOTAL_MAX
        Max subtotal for a pivot table field. Embedded value is 5.
        See Also:
        Constant Values
      • SUBTOTAL_MIN

        public const int SUBTOTAL_MIN
        Min subtotal for a pivot table field. Embedded value is 6.
        See Also:
        Constant Values
      • SUBTOTAL_PRODUCT

        public const int SUBTOTAL_PRODUCT
        Product subtotal for a pivot table field. Embedded value is 7.
        See Also:
        Constant Values
      • SUBTOTAL_COUNT

        public const int SUBTOTAL_COUNT
        Count subtotal for a pivot table field. Embedded value is 8.
        See Also:
        Constant Values
      • SUBTOTAL_STDEV

        public const int SUBTOTAL_STDEV
        StdDev subtotal for a pivot table field. Embedded value is 9.
        See Also:
        Constant Values
      • SUBTOTAL_STDEVP

        public const int SUBTOTAL_STDEVP
        StdDevP subtotal for a pivot table field. Embedded value is 10.
        See Also:
        Constant Values
      • SUBTOTAL_VAR

        public const int SUBTOTAL_VAR
        Var subtotal for a pivot table field. Embedded value is 11.
        See Also:
        Constant Values
      • SUBTOTAL_VARP

        public const int SUBTOTAL_VARP
        VarP subtotal for a pivot table field. Embedded value is 12.
        See Also:
        Constant Values
    • Constructor Detail

      • PivotTable

        public PivotTable()