以其他语言实现小计或总计标签

可能的使用场景

有时,您希望在中文、日文、阿拉伯语、印地语等非英语语言中显示小计和总计标签。Aspose.Cells允许您使用GlobalizationSettings类和Workbook.GlobalizationSettings 属性来实现这一点。请参阅此文章,了解如何使用GlobalizationSettings类。

以其他语言实现小计或总计标签

以下示例代码加载了样本Excel文件并在中文语言环境中实现了小计和总计的名称。请检查此代码生成的output Excel file以供参考。我们首先创建了GlobalizationSettings类,然后在我们的代码中使用它。

// 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 - 可能的用法";
}
}

现在在代码中使用上面创建的类,如下所示:

// 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");