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