以俄语或其他任何语言实现错误和布尔值
Contents
[
Hide
]
可能的使用场景
如果您在俄罗斯地区或使用俄语或其他语言的Microsoft Excel上使用,它将根据该地区或语言显示错误和布尔值。您可以使用Aspose.Cells来实现类似的行为,方法是使用 Workbook.Settings.GlobalizationSettings 属性。您需要重写 GlobalizationSettings 类的以下方法。
以俄语或其他任何语言实现错误和布尔值
以下示例代码说明了如何在俄语或其他任何语言中实现错误和布尔值。请查看此代码中使用的Sample Excel File及其Output PDF。屏幕截图显示了示例Excel文件和输出PDF之间的差异作为参考。
示例代码
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
//Russian Globalization | |
class RussianGlobalization : GlobalizationSettings | |
{ | |
public override string GetErrorValueString(string err) | |
{ | |
switch (err.ToUpper()) | |
{ | |
case "#NAME?": | |
return "#RussianName-имя?"; | |
} | |
return "RussianError-ошибка"; | |
} | |
public override string GetBooleanValueString(bool bv) | |
{ | |
return bv ? "RussianTrue-правда" : "RussianFalse-ложный"; | |
} | |
} | |
//-------------------------------- | |
//-------------------------------- | |
public class ImplementErrorsAndBooleanValueInRussianOrAnyOtherLanguage | |
{ | |
public static void Run() | |
{ | |
//Load the source workbook | |
Workbook wb = new Workbook("sampleRussianGlobalization.xlsx"); | |
//Set GlobalizationSettings in Russian Language | |
wb.Settings.GlobalizationSettings = new RussianGlobalization(); | |
//Calculate the formula | |
wb.CalculateFormula(); | |
//Save the workbook in pdf format | |
wb.Save("outputRussianGlobalization.pdf"); | |
} | |
} |