Implement Subtotal or Grand Total Labels in Other Languages

Possible Usage Scenarios

Sometimes, you want to show subtotal and grand total labels in non‑English languages such as Chinese, Japanese, Arabic, Hindi, etc. Aspose.Cells allows you to do this using the GlobalizationSettings class and the Workbook.GlobalizationSettings property. Please see this article on how to make use of the GlobalizationSettings class.

• Using GlobalizationSettings Class for Custom Subtotal Labels and Other Labels of a Pie Chart

Implement Subtotal or Grand Total Labels in Other Languages

The following sample code loads the sample Excel file and implements subtotal and grand total names in the Chinese language. Please check the output Excel file generated by this code for your reference. We first create an instance of the GlobalizationSettings class and then use it in our code.

Now use the above‑created class in the code as shown below: