使用Aspose.Cells中的FormulaText功能与Python.NET

Contents
[ ]

以下示例代码展示了使用Aspose.Cells的FORMULATEXT。代码首先在A1单元格写入一个公式,然后在A2单元格使用FORMULATEXT显示公式文本。

from aspose.cells import Workbook

# Create a workbook object
workbook = Workbook()

# Access first worksheet
worksheet = workbook.worksheets[0]

# Put some formula in cell A1
cell_a1 = worksheet.cells.get("A1")
cell_a1.formula = "=Sum(B1:B10)"

# Get the text of the formula in cell A2 using FORMULATEXT function
cell_a2 = worksheet.cells.get("A2")
cell_a2.formula = "=FormulaText(A1)"

# Calculate the workbook
workbook.calculate_formula()

# Print the results of A2, It will now print the text of the formula inside cell A1
print(cell_a2.string_value)

控制台输出

上述示例代码的控制台输出:

=SUM(B1:B10)