Hi ,
I am using aspose cells for java version aspose-cells-8.0.2.jar
Hyperlink to sheet1 in external file (Book1.xlsx) from XLSOldFormatFile.xls (older format) work without any issue with aspose api call.
Hyperlink to sheet1 in external file (Book1.xlsx) from XLSXNewFormatWorkbook.xlsx (new workbook format) does not work. attached is the output file.
Note: Using the fully qualified path in hyperlink address works but that option would not work for us. Is there any other alternate way to link external worksheet cell without using absolutefile path in hyperlink address?
Following is my test code. and attached are generated out put files for both test case
public class CostVolume633LinkTest {
public static void main(String[] args) throws Exception{
//Test case # 1 Instantiating a Workbook object -- for older (Excel 97-2003) file format
Workbook xlsFile = new Workbook();
//Obtaining the reference of the first worksheet.
WorksheetCollection xlsSheets = xlsFile.getWorksheets();
Worksheet xlsSheet = xlsSheets.get(0);
HyperlinkCollection xlsHyperLink = xlsSheet.getHyperlinks();
//Adding a link to the external file
xlsHyperLink.add("A5", 1, 1, "Book1.xlsx#sheet1!A1");
//Saving the Excel file
xlsFile.save("C:\\asposeTest\\XLSOldFormatFile.xls");
System.out.println("Excel 2003 format file hyperlink address "+xlsFile.getWorksheets().get(0).getHyperlinks().get(0).getAddress());
////Test case # 2 Instantiating a Workbook object -- for new file format(excel workbook )
Workbook xlsxFile = new Workbook();
//Obtaining the reference of the first worksheet.
WorksheetCollection xlsxSheets = xlsxFile.getWorksheets();
Worksheet xlsxSheet = xlsxSheets.get(0);
HyperlinkCollection xlsxHyperLink = xlsxSheet.getHyperlinks();
//Adding a link to the external file
xlsxHyperLink.add("A5", 1, 1, "Book1.xlsx#sheet1!A1");
//Saving the Excel file
xlsxFile.save("C:\\asposeTest\\XLSXNewFormatWorkbook.xlsx");
System.out.println("Excel 2003 format file hyperlink address "+xlsxFile.getWorksheets().get(0).getHyperlinks().get(0).getAddress());
}
}
Thanks,