// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1").setFormula("='null/api/sample/[SourceWorkbook.xlsx]Sheet1'!A1"); for (String requestUri : workbook.getExcelLinkSources()) { Workbook externalWorkbook = new Workbook(); // This operation may throw Exception. // Because the highest supported TLS version in environment dependent. InputStream stream; try { stream = new URL(requestUri).openStream(); externalWorkbook.open(stream); } catch (MalformedURLException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } workbook.updateExcelLink(requestUri, externalWorkbook); } // Save to an excel file workbook.save("ExternalWorkbookLinks.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet: IWorksheet = workbook.getWorksheets().get(0) workbook.getWorksheets().get(0).getRange("A1").setFormula("='null/api/sample/[SourceWorkbook.xlsx]Sheet1'!A1") for (requestUri in workbook.getExcelLinkSources()) { val externalWorkbook = Workbook() // This operation may throw Exception. // Because the highest supported TLS version in environment dependent. var stream: InputStream? try { stream = URL(requestUri).openStream() externalWorkbook.open(stream) } catch (e: MalformedURLException) { e.printStackTrace() } catch (e: IOException) { e.printStackTrace() } workbook.updateExcelLink(requestUri, externalWorkbook) } // Save to an excel file workbook.save("ExternalWorkbookLinks.xlsx")