SettablePivotGlobalizationSettings class

Implementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.

Inheritance: SettablePivotGlobalizationSettings → PivotGlobalizationSettings

The SettablePivotGlobalizationSettings type exposes the following members:

Constructors

Constructor	Description
`__init__(self)`	Constructs a new instance of SettablePivotGlobalizationSettings

Methods

Method	Description
`get_text_of_total(self)`	Gets the text of “Total” label in the PivotTable. You need to override this method when the PivotTable contains two or more PivotFields in the data area.
`get_text_of_grand_total(self)`	Gets the text of “Grand Total” label in the PivotTable.
`get_text_of_multiple_items(self)`	Gets the text of “(Multiple Items)” label in the PivotTable.
`get_text_of_all(self)`	Gets the text of “(All)” label in the PivotTable.
`get_text_of_protection(self)`	Gets the protection name in the PivotTable.
`get_text_of_protected_name(self, protected_name)`	Gets the text for specified protected name.
`get_text_of_column_labels(self)`	Gets the text of “Column Labels” label in the PivotTable.
`get_text_of_row_labels(self)`	Gets the text of “Row Labels” label in the PivotTable.
`get_text_of_empty_data(self)`	Gets the text of “(blank)” label in the PivotTable.
`get_text_of_data_field_header(self)`	Gets the the text of the value area field header in the PivotTable.
`get_short_text_of_12_months(self)`	Gets all short formatted string of 12 months.
`get_text_of_24_hours(self)`	Gets all local formatted string of 24 hours. The default value is 12 AM, 1 AM, 2 AM, 3 AM, 4 AM, 5 AM, 6 AM, 7 AM, 8 AM, 9 AM, 10 AM, 11 AM, 12 PM, 1 PM, 2 PM, 3 PM, 4 PM, 5 PM, 6 PM, 7 PM, 8 PM, 9 PM, 10 PM, 11 PM.
`get_text_of_or(self)`	Gets all local formatted string of “or”.
`get_format_of_day_group(self)`	Gets the number format of pivot day group. Only used when grouping the pivot field by days. The default vaule is “d-MMM”;
`get_text_of_4_quaters(self)`	Gets the local text of 4 Quarters.
`get_text_of_4_quarters(self)`	Gets the local text of 4 Quarters.
`get_text_of_years(self)`	Gets the local text of “Years”.
`get_text_of_quarters(self)`	Get the local text of “Quarters”.
`get_text_of_months(self)`	Gets the local text of “Months”.
`get_text_of_days(self)`	Gets the local text of “Days”.
`get_text_of_hours(self)`	Gets the local text of “Hours”.
`get_text_of_minutes(self)`	Gets the local text of “Minutes”.
`get_text_of_seconds(self)`	Gets the local text of “Seconds”
`get_text_of_range(self)`	Gets the local text of “Range”
`get_text_of_all_periods(self)`	Gets the localized text of “All Periods”.
`get_name_of_data_field(self, function, name)`	Gets the display name of data pivot field. The default format is “Sum Of Field”.
`get_text_of_sub_total(self, sub_total_type)`	Gets the text of `PivotFieldSubtotalType` type in the PivotTable.
`set_text_of_total(self, text)`	Sets the text of “Total” label in the PivotTable.
`set_text_of_grand_total(self, text)`	Sets the text of “Grand Total” label in the PivotTable.
`set_text_of_multiple_items(self, text)`	Sets the text of “(Multiple Items)” label in the PivotTable.
`set_text_of_all(self, text)`	Sets the text of “(All)” label in the PivotTable.
`set_text_of_protected_name(self, protected_name, text)`	Sets the text for specific protected name.
`set_text_of_column_labels(self, text)`	Gets the text of “Column Labels” label in the PivotTable.
`set_text_of_row_labels(self, text)`	Sets the text of “Row Labels” label in the PivotTable.
`set_text_of_empty_data(self, text)`	Sets the text of “(blank)” label in the PivotTable.
`set_text_of_data_field_header(self, text)`	Sets the the text of the value area field header in the PivotTable.
`set_text_of_sub_total(self, sub_total_type, text)`	Sets the text of `PivotFieldSubtotalType` type in the PivotTable.

SettablePivotGlobalizationSettings class

SettablePivotGlobalizationSettings class

Constructors

Methods

See Also