Показать формулы вместо значений в рабочем листе

Contents
[ ]

Aspose.Cells для Python via .NET предоставляет свойство Worksheet.show_formulas. Установите его в true, чтобы Excel отображал формулы.

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(".")
filePath = dataDir + "source.xlsx"
# Load the source workbook
workbook = Workbook(filePath)
# Access the first worksheet
worksheet = workbook.worksheets[0]
# Show formulas of the worksheet
worksheet.show_formulas = True
# Save the workbook
workbook.save(dataDir + ".out.xlsx")