Add Cells to Microsoft Excel Formula Watch Window with Python.NET

Possible Usage Scenarios

Microsoft Excel Watch Window is a useful tool to monitor cell values and formulas conveniently in a dedicated window. You can open the Watch Window in Microsoft Excel by navigating to Formulas > Watch Window. The Add Watch button allows adding cells for inspection. Similarly, you can use the Worksheet.cell_watches.add() method to programmatically add cells to the Watch Window using Aspose.Cells API.

Add Cells to Microsoft Excel Formula Watch Window

The following sample code sets formulas for cells C1 and E1, then adds both to the Watch Window. It saves the workbook as the output Excel file. When opening the output file in Excel, both cells will appear in the Watch Window as shown:

Sample Code

from aspose.cells import Workbook, SaveFormat

# Create an empty workbook.
wb = Workbook()

# Access first worksheet.
ws = wb.worksheets[0]

# Put some integer values in cells A1 and A2.
ws.cells.get("A1").put_value(10)
ws.cells.get("A2").put_value(30)

# Access cell C1 and set its formula.
c1 = ws.cells.get("C1")
c1.formula = "=Sum(A1,A2)"

# Add cell C1 to cell watches by name.
ws.cell_watches.add(c1.name)

# Access cell E1 and set its formula.
e1 = ws.cells.get("E1")
e1.formula = "=A2*A1"

# Add cell E1 to cell watches using its row and column indices.
ws.cell_watches.add(e1.row, e1.column)

# Save workbook to output XLSX format.
wb.save("outputAddCellsToMicrosoftExcelFormulaWatchWindow.xlsx", SaveFormat.XLSX)