// Create a new workbook Workbook workbook = new Workbook(); workbook.open(this.getResourceStream("xlsx/Urban Centers 2017.xlsx")); Workbook flints = new Workbook(); flints.open(this.getResourceStream("xlsx/Flints.xlsx")); Workbook jackson = new Workbook(); jackson.open(this.getResourceStream("xlsx/Jackson.xlsx")); Workbook petrosky = new Workbook(); petrosky.open(this.getResourceStream("xlsx/Petrosky.xlsx")); workbook.getWorksheets().get(0).getRange("B6:E11").setFormula("='[Flints.xlsx]Sheet1'!B7+'[Jackson.xlsx]Sheet1'!B6+'[Petrosky.xlsx]Sheet1'!B7"); workbook.updateExcelLink("Flints.xlsx", flints); workbook.updateExcelLink("Jackson.xlsx", jackson); workbook.updateExcelLink("Petrosky.xlsx", petrosky); workbook.calculate(); // Save to an excel file workbook.save("CrossWorkbookFormula2.xlsx");
// Create a new workbook var workbook = Workbook() workbook.open(this.getResourceStream("xlsx/Urban Centers 2017.xlsx")) val flints = Workbook() flints.open(this.getResourceStream("xlsx/Flints.xlsx")) val jackson = Workbook() jackson.open(this.getResourceStream("xlsx/Jackson.xlsx")) val petrosky = Workbook() petrosky.open(this.getResourceStream("xlsx/Petrosky.xlsx")) workbook.getWorksheets().get(0).getRange("B6:E11") .setFormula("='[Flints.xlsx]Sheet1'!B7+'[Jackson.xlsx]Sheet1'!B6+'[Petrosky.xlsx]Sheet1'!B7") workbook.updateExcelLink("Flints.xlsx", flints) workbook.updateExcelLink("Jackson.xlsx", jackson) workbook.updateExcelLink("Petrosky.xlsx", petrosky) workbook.calculate() // Save to an excel file workbook.save("CrossWorkbookFormula2.xlsx")