Ange externa länkar i formler

Contents
[ ]

Det exempelkod nedan visar hur du inkluderar externa filer i formler.

// 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");