使用Python.NET计算数据表的数组公式
Contents
[
Hide
]
你可以在Microsoft Excel中使用数据 > 假设分析 > 数据表来创建数据表…… Aspose.Cells for Python via .NET允许你计算数据表的数组公式。请像平常一样使用 workbook.calculate_formula() 进行任何类型公式的计算。
在下面的示例中,我们使用源Excel文件。如果你将单元格B1的值改为100,数据表(用黄色突出显示)的值将更新为120,如下图所示。Python代码生成了这个输出PDF。
以下是演示如何从源Excel文件生成输出PDF的Python实现:
import os
from aspose.cells import Workbook
# For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
current_dir = os.path.dirname(os.path.abspath(__file__))
data_dir = os.path.join(current_dir, "data")
# Create workbook from source excel file
workbook = Workbook(os.path.join(data_dir, "DataTable.xlsx"))
# Access first worksheet
worksheet = workbook.worksheets[0]
# When you will put 100 in B1, then all Data Table values formatted as Yellow will become 120
worksheet.cells.get("B1").put_value(100)
# Calculate formula, now it also calculates Data Table array formula
workbook.calculate_formula()
# Save the workbook in pdf format
workbook.save(os.path.join(data_dir, "output_out.pdf"))
Python代码说明:
import aspose.cells as ac
# Load source workbook
workbook = ac.Workbook("5115535.xlsx")
# Calculate formulas using Python.NET API
workbook.calculate_formula()
# Save the workbook in PDF format
workbook.save("5115538.pdf", ac.SaveFormat.PDF)