以其他语言实现小计或总计标签
Contents
[
Hide
]
可能的使用场景
有时,您希望在中文、日文、阿拉伯语、印地语等非英语语言中显示小计和总计标签。Aspose.Cells允许您使用GlobalizationSettings类和Workbook.GlobalizationSettings 属性来实现这一点。请参阅此文章,了解如何使用GlobalizationSettings类。
以其他语言实现小计或总计标签
以下示例代码加载了样本Excel文件并在中文语言环境中实现了小计和总计的名称。请检查此代码生成的output Excel file以供参考。我们首先创建了GlobalizationSettings类,然后在我们的代码中使用它。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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 - 可能的用法"; | |
} | |
} |
现在在代码中使用上面创建的类,如下所示:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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"); |