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 like Chinese, Japanese, Arabic, Hindi etc. Aspose.Cells allows you to do this using the GlobalizationSettings class and Workbook.GlobalizationSettings property. Please see this article on how to make use of GlobalizationSettings class
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 a class of GlobalizationSettings and then use it in our code.
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
class GlobalizationSettingsImp : GlobalizationSettings | |
{ | |
// This function will return the sub total name | |
public override String GetTotalName(ConsolidationFunction functionType) | |
{ | |
return "Chinese Total - 可能的用法"; | |
} | |
// This function will return the grand total name | |
public override String GetGrandTotalName(ConsolidationFunction functionType) | |
{ | |
return "Chinese Grand Total - 可能的用法"; | |
} | |
} |
Now use above created class in the code like below:
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Load your source workbook | |
Workbook wb = new Workbook(dataDir + "sample.xlsx"); | |
// Set the glorbalization setting to change subtotal and grand total names | |
GlobalizationSettings gsi = new GlobalizationSettingsImp(); | |
wb.Settings.GlobalizationSettings = gsi; | |
// Access first worksheet | |
Worksheet ws = wb.Worksheets[0]; | |
// Apply subtotal on A1:B10 | |
CellArea ca = CellArea.CreateCellArea("A1", "B10"); | |
ws.Cells.Subtotal(ca, 0, ConsolidationFunction.Sum, new int[] { 2, 3, 4 }); | |
// Set the width of the first column | |
ws.Cells.SetColumnWidth(0, 40); | |
// Save the output excel file | |
wb.Save(dataDir + "output_out.xlsx"); |