为工作簿指定自定义数字小数点和分组分隔符
Contents
[
Hide
]
在Microsoft Excel中,您可以在“高级Excel选项”中指定自定义十进制和千位分隔符,而不是使用系统分隔符,如下面的屏幕截图所示。
Aspose.Cells for Python via .NET 提供 WorkbookSettings.number_decimal_separator 和 WorkbookSettings.number_group_separator 属性,用于设置自定义分隔符以格式化或解析数字。
使用Microsoft Excel指定自定义分隔符
下面的屏幕截图显示了“高级Excel选项”,并突出显示了指定“自定义分隔符”的部分。
使用 Aspose.Cells for Python via .NET 指定自定义分隔符
以下示例代码说明如何使用 Aspose.Cells for Python via .NET API 指定自定义分隔符。它将数字的小数点和分组分隔符分别设置为点和空格。
用于指定自定义数字小数点和分组分隔符的C#代码
This file contains hidden or 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
from aspose.cells import Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# The path to the documents directory. | |
dataDir = RunExamples.GetDataDir(".") | |
workbook = Workbook() | |
# Specify custom separators | |
workbook.settings.number_decimal_separator = '.' | |
workbook.settings.number_group_separator = ' ' | |
worksheet = workbook.worksheets[0] | |
# Set cell value | |
cell = worksheet.cells.get("A1") | |
cell.put_value(123456.789) | |
# Set custom cell style | |
style = cell.get_style() | |
style.custom = "#,##0.000;[Red]#,##0.000" | |
cell.set_style(style) | |
worksheet.auto_fit_columns() | |
# Save workbook as pdf | |
workbook.save(dataDir + "CustomSeparator_out.pdf") |