Namespace EasyXLS.Constants

Class PivotTable

System.Object

EasyXLS.Constants.PivotTable

public class PivotTable
extends System.Object

This class contains the constants for the pivot tables.

Constant Summary

Fields

Modifier and Type	Field	Description
const int	AREA_COLUMN_LABELS	A constant indicating that the pivot table field is added to column labels area.
const int	AREA_NONE	A constant indicating that the pivot table field is not added to any area.
const int	AREA_REPORT_FILTER	A constant indicating that the pivot table field is added to report filter area.
const int	AREA_ROW_LABELS	A constant indicating that the pivot table field is added to row labels area.
const System.String	AUTOFORMAT_NONE	A constant indicating that no autoformat is applied for the pivot table.
const System.String	AUTOFORMAT_PIVOTTABLE_CLASIC	Pivot style (Autoformat) Pivot Table Clasic for a pivot table.
const System.String	AUTOFORMAT_REPORT_1	Pivot style (Autoformat) Report 1 for a pivot table.
const System.String	AUTOFORMAT_REPORT_10	Pivot style (Autoformat) Report 10 for a pivot table.
const System.String	AUTOFORMAT_REPORT_2	Pivot style (Autoformat) Report 2 for a pivot table.
const System.String	AUTOFORMAT_REPORT_3	Pivot style (Autoformat) Report 3 for a pivot table.
const System.String	AUTOFORMAT_REPORT_4	Pivot style (Autoformat) Report 4 for a pivot table.
const System.String	AUTOFORMAT_REPORT_5	Pivot style (Autoformat) Report 5 for a pivot table.
const System.String	AUTOFORMAT_REPORT_6	Pivot style (Autoformat) Report 6 for a pivot table.
const System.String	AUTOFORMAT_REPORT_7	Pivot style (Autoformat) Report 7 for a pivot table.
const System.String	AUTOFORMAT_REPORT_8	Pivot style (Autoformat) Report 8 for a pivot table.
const System.String	AUTOFORMAT_REPORT_9	Pivot style (Autoformat) Report 9 for a pivot table.
const System.String	AUTOFORMAT_TABLE_1	Pivot style (Autoformat) Table 1 for a pivot table.
const System.String	AUTOFORMAT_TABLE_10	Pivot style (Autoformat) Table 10 for a pivot table.
const System.String	AUTOFORMAT_TABLE_2	Pivot style (Autoformat) Table 2 for a pivot table.
const System.String	AUTOFORMAT_TABLE_3	Pivot style (Autoformat) Table 3 for a pivot table.
const System.String	AUTOFORMAT_TABLE_4	Pivot style (Autoformat) Table 4 for a pivot table.
const System.String	AUTOFORMAT_TABLE_5	Pivot style (Autoformat) Table 5 for a pivot table.
const System.String	AUTOFORMAT_TABLE_6	Pivot style (Autoformat) Table 6 for a pivot table.
const System.String	AUTOFORMAT_TABLE_7	Pivot style (Autoformat) Table 7 for a pivot table.
const System.String	AUTOFORMAT_TABLE_8	Pivot style (Autoformat) Table 8 for a pivot table.
const System.String	AUTOFORMAT_TABLE_9	Pivot style (Autoformat) Table 9 for a pivot table.
const System.String	PIVOT_STYLE_DARK_1	Pivot style Dark 1 for a pivot table.
const System.String	PIVOT_STYLE_DARK_10	Pivot style Dark 10 for a pivot table.
const System.String	PIVOT_STYLE_DARK_11	Pivot style Dark 11 for a pivot table.
const System.String	PIVOT_STYLE_DARK_12	Pivot style Dark 12 for a pivot table.
const System.String	PIVOT_STYLE_DARK_13	Pivot style Dark 13 for a pivot table.
const System.String	PIVOT_STYLE_DARK_14	Pivot style Dark 14 for a pivot table.
const System.String	PIVOT_STYLE_DARK_15	Pivot style Dark 15 for a pivot table.
const System.String	PIVOT_STYLE_DARK_16	Pivot style Dark 16 for a pivot table.
const System.String	PIVOT_STYLE_DARK_17	Pivot style Dark 17 for a pivot table.
const System.String	PIVOT_STYLE_DARK_18	Pivot style Dark 18 for a pivot table.
const System.String	PIVOT_STYLE_DARK_19	Pivot style Dark 19 for a pivot table.
const System.String	PIVOT_STYLE_DARK_2	Pivot style Dark 2 for a pivot table.
const System.String	PIVOT_STYLE_DARK_20	Pivot style Dark 20 for a pivot table.
const System.String	PIVOT_STYLE_DARK_21	Pivot style Dark 21 for a pivot table.
const System.String	PIVOT_STYLE_DARK_22	Pivot style Dark 22 for a pivot table.
const System.String	PIVOT_STYLE_DARK_23	Pivot style Dark 23 for a pivot table.
const System.String	PIVOT_STYLE_DARK_24	Pivot style Dark 24 for a pivot table.
const System.String	PIVOT_STYLE_DARK_25	Pivot style Dark 25 for a pivot table.
const System.String	PIVOT_STYLE_DARK_26	Pivot style Dark 26 for a pivot table.
const System.String	PIVOT_STYLE_DARK_27	Pivot style Dark 27 for a pivot table.
const System.String	PIVOT_STYLE_DARK_28	Pivot style Dark 28 for a pivot table.
const System.String	PIVOT_STYLE_DARK_3	Pivot style Dark 3 for a pivot table.
const System.String	PIVOT_STYLE_DARK_4	Pivot style Dark 4 for a pivot table.
const System.String	PIVOT_STYLE_DARK_5	Pivot style Dark 5 for a pivot table.
const System.String	PIVOT_STYLE_DARK_6	Pivot style Dark 6 for a pivot table.
const System.String	PIVOT_STYLE_DARK_7	Pivot style Dark 7 for a pivot table.
const System.String	PIVOT_STYLE_DARK_8	Pivot style Dark 8 for a pivot table.
const System.String	PIVOT_STYLE_DARK_9	Pivot style Dark 9 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_1	Pivot style Light 1 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_10	Pivot style Light 10 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_11	Pivot style Light 11 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_12	Pivot style Light 12 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_13	Pivot style Light 13 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_14	Pivot style Light 14 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_15	Pivot style Light 15 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_16	Pivot style Light 16 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_17	Pivot style Light 17 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_18	Pivot style Light 18 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_19	Pivot style Light 19 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_2	Pivot style Light 2 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_20	Pivot style Light 20 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_21	Pivot style Light 21 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_22	Pivot style Light 22 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_23	Pivot style Light 23 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_24	Pivot style Light 24 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_25	Pivot style Light 25 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_26	Pivot style Light 26 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_27	Pivot style Light 27 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_28	Pivot style Light 28 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_3	Pivot style Light 3 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_4	Pivot style Light 4 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_5	Pivot style Light 5 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_6	Pivot style Light 6 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_7	Pivot style Light 7 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_8	Pivot style Light 8 for a pivot table.
const System.String	PIVOT_STYLE_LIGHT_9	Pivot style Light 9 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_1	Pivot style Medium 1 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_10	Pivot style Medium 10 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_11	Pivot style Medium 11 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_12	Pivot style Medium 12 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_13	Pivot style Medium 13 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_14	Pivot style Medium 14 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_15	Pivot style Medium 15 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_16	Pivot style Medium 16 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_17	Pivot style Medium 17 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_18	Pivot style Medium 18 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_19	Pivot style Medium 19 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_2	Pivot style Medium 2 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_20	Pivot style Medium 20 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_21	Pivot style Medium 21 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_22	Pivot style Medium 22 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_23	Pivot style Medium 23 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_24	Pivot style Medium 24 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_25	Pivot style Medium 25 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_26	Pivot style Medium 26 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_27	Pivot style Medium 27 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_28	Pivot style Medium 28 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_3	Pivot style Medium 3 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_4	Pivot style Medium 4 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_5	Pivot style Medium 5 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_6	Pivot style Medium 6 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_7	Pivot style Medium 7 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_8	Pivot style Medium 8 for a pivot table.
const System.String	PIVOT_STYLE_MEDIUM_9	Pivot style Medium 9 for a pivot table.
const System.String	PIVOT_STYLE_NONE	A constant indicating that no style is applied for the pivot table.
const int	SORT_A_TO_Z	Ascending order from A to Z.
const int	SORT_IN_DATA_SOURCE_ORDER	Sort order according to data source order.
const int	SORT_MANUAL	Manual order.
const int	SORT_Z_TO_A	Descending order from Z to A.
const int	SUBTOTAL_AUTOMATIC	Automatic subtotal for a pivot table field.
const int	SUBTOTAL_AVERAGE	Average subtotal for a pivot table field.
const int	SUBTOTAL_COUNT	Count subtotal for a pivot table field.
const int	SUBTOTAL_COUNTA	CountA subtotal for a pivot table field.
const int	SUBTOTAL_MAX	Max subtotal for a pivot table field.
const int	SUBTOTAL_MIN	Min subtotal for a pivot table field.
const int	SUBTOTAL_NONE	A constant indicating that no subtotal is applied for a pivot table field.
const int	SUBTOTAL_PRODUCT	Product subtotal for a pivot table field.
const int	SUBTOTAL_STDEV	StdDev subtotal for a pivot table field.
const int	SUBTOTAL_STDEVP	StdDevP subtotal for a pivot table field.
const int	SUBTOTAL_SUM	Sum subtotal for a pivot table field.
const int	SUBTOTAL_VAR	Var subtotal for a pivot table field.
const int	SUBTOTAL_VARP	VarP subtotal for a pivot table field.
const System.String	SUM_VALUES_FIELD	A constant indicating the summarization special field.

Constructor Summary

Constructors

Constructor	Description
PivotTable()

Method Summary

Methods inherited from class System.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

AREA_NONE

public const final 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 final 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 final 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 final 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 final 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 final int SORT_IN_DATA_SOURCE_ORDER

Sort order according to data source order. Valid for pivot table only. Embedded value is 1.

See Also:

• Constant Values

SORT_Z_TO_A

public const final int SORT_Z_TO_A

Descending order from Z to A. Embedded value is 2.

See Also:

• Constant Values

SORT_MANUAL

public const final int SORT_MANUAL

Manual order. Valid for pivot table field only. Embedded value is 3.

See Also:

• Constant Values

PIVOT_STYLE_NONE

public const final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final int SUBTOTAL_AUTOMATIC

Automatic subtotal for a pivot table field. Embedded value is 1.

See Also:

• Constant Values

SUBTOTAL_SUM

public const final int SUBTOTAL_SUM

Sum subtotal for a pivot table field. Embedded value is 2.

See Also:

• Constant Values

SUBTOTAL_COUNTA

public const final int SUBTOTAL_COUNTA

CountA subtotal for a pivot table field. Embedded value is 3.

See Also:

• Constant Values

SUBTOTAL_AVERAGE

public const final int SUBTOTAL_AVERAGE

Average subtotal for a pivot table field. Embedded value is 4.

See Also:

• Constant Values

SUBTOTAL_MAX

public const final int SUBTOTAL_MAX

Max subtotal for a pivot table field. Embedded value is 5.

See Also:

• Constant Values

SUBTOTAL_MIN

public const final int SUBTOTAL_MIN

Min subtotal for a pivot table field. Embedded value is 6.

See Also:

• Constant Values

SUBTOTAL_PRODUCT

public const final int SUBTOTAL_PRODUCT

Product subtotal for a pivot table field. Embedded value is 7.

See Also:

• Constant Values

SUBTOTAL_COUNT

public const final int SUBTOTAL_COUNT

Count subtotal for a pivot table field. Embedded value is 8.

See Also:

• Constant Values

SUBTOTAL_STDEV

public const final int SUBTOTAL_STDEV

StdDev subtotal for a pivot table field. Embedded value is 9.

See Also:

• Constant Values

SUBTOTAL_STDEVP

public const final int SUBTOTAL_STDEVP

StdDevP subtotal for a pivot table field. Embedded value is 10.

See Also:

• Constant Values

SUBTOTAL_VAR

public const final int SUBTOTAL_VAR

Var subtotal for a pivot table field. Embedded value is 11.

See Also:

• Constant Values

SUBTOTAL_VARP

public const final int SUBTOTAL_VARP

VarP subtotal for a pivot table field. Embedded value is 12.

See Also:

• Constant Values

Constructor Details

PivotTable

public PivotTable()