Using FormulaText Function in Aspose.Cells with Python.NET

FORMULATEXT is an Excel 2013 and later function. It is not supported by previous versions like Excel 2010 or 2007 etc. As its name suggests, it displays the formula text contained in a specified cell. This article demonstrates how to use this function with Aspose.Cells for Python via .NET.

The following sample code demonstrates using FORMULATEXT with Aspose.Cells. The code first writes a formula in cell A1 and then displays the formula text using FORMULATEXT in cell A2.

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)

Console Output

Here is the console output of the above sample code:

=SUM(B1:B10)