在公式中设置外部链接

有时，需要在公式中包含指向外部文件的链接，例如，根据它们计算单元格或范围值。 Aspose.Cells 提供了这个功能，这个文档解释了如何使用它

下面的示例代码显示了如何在公式中包含外部文件。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
String dataDir = Utils.getDataDir(SetExternalLinksInFormulas.class);
// Instantiate a new Workbook.
Workbook workbook = new Workbook();

// Get first Worksheet
Worksheet sheet = workbook.getWorksheets().get(0);

// Get Cells collection
Cells cells = sheet.getCells();

// Set formula with external links
cells.get("A1").setFormula("=SUM('[F:\\book1.xls]Sheet1'!A2, '[F:\\book1.xls]Sheet1'!A4)");

// Set formula with external links
cells.get("A2").setFormula("='[F:\\book1.xls]Sheet1'!A8");

// Save the workbook
workbook.save(dataDir + "output.xls");