使用Python.NET设置Workbook的公式计算模式
Contents
[
Hide
]
在工作簿中设置公式计算模式
Microsoft Excel提供三种公式计算模式:
- 自动:每次更改和打开工作簿时重新计算公式
- 除数据表外自动:在更改时重新计算公式,除数据表外
- 手动:仅在用户请求(F9/CTRL+ALT+F9)或保存时重新计算
使用Aspose.Cells设置计算模式
Aspose.Cells for Python via .NET通过Workbook.settings属性提供formula_settings配置。使用calculation_mode属性控制计算行为。
通过CalcModeType枚举提供的可用模式:
AUTOMATIC
AUTOMATIC_EXCEPT_TABLE
MANUAL
实现步骤:
- 加载现有工作簿或创建新实例
- 访问工作簿设置
- 使用
formula_settings.calculation_mode
设置计算模式 - 保存修改后的工作簿
from aspose.cells import Workbook, CalcModeType
# Load source workbook
workbook = Workbook("source.xlsx")
# Configure manual calculation mode
workbook.settings.formula_settings.calculation_mode = CalcModeType.MANUAL
# Save modified workbook
workbook.save("output.xlsx")
import os
from aspose.cells import Workbook, CalcModeType, SaveFormat
# For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
# The path to the documents directory.
current_dir = os.path.dirname(os.path.abspath(__file__))
data_dir = os.path.join(current_dir, "data")
# Create a workbook
workbook = Workbook()
# Set the Formula Calculation Mode to Manual
workbook.settings.formula_settings.calculation_mode = CalcModeType.MANUAL
# Save the workbook
output_path = os.path.join(data_dir, "output_out.xlsx")
workbook.save(output_path, SaveFormat.XLSX)