Customize Globalization Settings for Pivot Table with Golang via C++
Possible Usage Scenarios
Sometimes you want to customize the Pivot Total, Sub Total, Grand Total, All Items, Multiple Items, Column Labels, Row Labels, Blank Values text as per your requirements. Aspose.Cells for C++ allows you to customize the globalization settings of the pivot table to deal with such scenarios. You can also use this feature to change the labels to other languages like Arabic, Hindi, Polish, etc.
Customize Globalization Settings for Pivot Table
The following sample code explains how to customize globalization settings for the pivot table in C++. It creates a class CustomPivotTableGlobalizationSettings derived from the base class PivotGlobalizationSettings and overrides all necessary methods. These methods return customized text for various pivot table elements. The code then assigns this implementation to the WorkbookSettings.GetPivotSettings() property. The example loads a source Excel file, refreshes pivot data, and saves it as output PDF. The screenshot below shows customized labels in the output.
