Add Cells to Microsoft Excel Formula Watch Window

Possible Usage Scenarios

Microsoft Excel Watch Window is a useful tool to watch cell values and its formulas conveniently in a window. You can open the Watch Window in Microsoft Excel by clicking Formulas > Watch Window. It has the Add Watch button that can be used to add the cells for inspection. Similarly, you can use the Worksheet.getCellWatches().add() method to add cells to the Watch Window using the Aspose.Cells API.

Add Cells to Microsoft Excel Formula Watch Window

The following sample code sets the formulas of cells C1 and E1 and adds both of them to the Watch Window. It then saves the workbook as the output Excel file. If you open the output Excel file and view the Watch Window, you will see both cells as shown in this screenshot.

Sample Code