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_4_quaters(self)`	Gets the local text of 4 Quaters.
`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_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