使用Node.js通过C++将单元格添加到Microsoft Excel公式监视窗口的方法
Contents
[
Hide
]
可能的使用场景
Microsoft Excel的监控窗口是一个方便的工具,可在窗口中观察单元格值及其公式。你可以通过点击公式 > 监控窗口在Microsoft Excel中打开监控窗口。它有添加监控按钮,用于添加待检查的单元格。同样,你可以使用CellWatchCollection.add(number, number)方法通过Aspose.Cells API将单元格添加到监控窗口。
将单元格添加到Microsoft Excel公式监视窗口
以下示例代码设置了单元格C1和E1的公式,并将它们添加到监控窗口。然后将工作簿保存为输出Excel文件。如果你打开输出Excel文件并查看监控窗口,你将看到两个单元格,如截图所示。
示例代码
const path = require("path");
const AsposeCells = require("aspose.cells.node");
// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "sample.xlsx");
// Create empty workbook.
const wb = new AsposeCells.Workbook();
// Access first worksheet.
const ws = wb.getWorksheets().get(0);
// Put some integer values in cell A1 and A2.
ws.getCells().get("A1").putValue(10);
ws.getCells().get("A2").putValue(30);
// Access cell C1 and set its formula.
const c1 = ws.getCells().get("C1");
c1.setFormula("=Sum(A1,A2)");
// Add cell C1 into cell watches by name.
ws.getCellWatches().add(c1.getName());
// Access cell E1 and set its formula.
const e1 = ws.getCells().get("E1");
e1.setFormula("=A2*A1");
// Add cell E1 into cell watches by its row and column indices.
ws.getCellWatches().add(e1.getRow(), e1.getColumn());
// Save workbook to output XLSX format.
wb.save("outputAddCellsToMicrosoftExcelFormulaWatchWindow.xlsx", AsposeCells.SaveFormat.Xlsx);