Bug 58507 - public external link access at Workbook level
Summary: public external link access at Workbook level
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC All
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-10-20 07:51 UTC by Dominique De Munck
Modified: 2015-11-04 20:27 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dominique De Munck 2015-10-20 07:51:45 UTC
Hello

Listing all external links in .xlsx files is easy, just call XSSFWorkbook.getExternalLinksTable() and iterate over them.
No alternative in HSSFWorkbook currently exists.
It would be very nice to implement this functionality and offer it at the abstract Workbook level.

See also this thread with the current very dirty workaround and suggestion that this enhancement request should be created:

http://stackoverflow.com/questions/26758099/how-to-extract-a-list-of-external-references-from-a-excel-file
Comment 1 Nick Burch 2015-10-22 14:08:42 UTC
The two file formats store external references in very different ways, so I'm not sure how possible it is to offer a common interface across them

That said... If you can come up with a good interface, that will work for both, and exposes useful information, we can certainly look at adding it!
Comment 2 Dominik Stadler 2015-11-02 12:41:32 UTC
I think this is now fixed via bug 58572

*** This bug has been marked as a duplicate of bug 58572 ***
Comment 3 Javen O'Neal 2015-11-02 13:21:16 UTC
bug 58572 creates a common interface for Hyperlinks (URLs, emails, document links, and files). It does not provide a common interface for External Links.

From XSSFWorkbook java docs:
getExternalLinksTable
The external links table specifies details of named ranges etc
     *  that are referenced from other workbooks, along with the last seen
     *  values of what they point to.

I'm reopening this bug because I'm assuming Dominique wasn't looking for common Hyperlink support.
Comment 4 Dominik Stadler 2015-11-04 20:27:19 UTC
Yep, good catch, it seems I did not look too closely here!