为工作簿指定自定义数字小数点和分组分隔符

使用Microsoft Excel指定自定义分隔符

下面的屏幕截图显示了“高级Excel选项”,并突出显示了指定“自定义分隔符”的部分。

todo:image_alt_text

使用 Aspose.Cells for Python via .NET 指定自定义分隔符

以下示例代码说明如何使用 Aspose.Cells for Python via .NET API 指定自定义分隔符。它将数字的小数点和分组分隔符分别设置为点和空格。

用于指定自定义数字小数点和分组分隔符的C#代码

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