Resolve filename for external links in formulas - ExternalLinksTable

Apr 25, 2016 at 5:51 PM
I've been unsuccessful in getting the ExternalLinksTable from a workbook.

The $cell.CellFormula is: [1]Sheet1!$B$2 where [1] references an external workbook.

Using NPOI, how can I find the name of the external sheet? Basically expand the formula to include the external workbook name?

getExternalLinksTable() is not found.
$wb.getExternalLinksTable();

This seems to be in POI, but I've been unsuccessful using this with NPOI.
Apr 25, 2016 at 6:08 PM
May have found the answer - downloaded the beta version of NPOI and ExternalLinksTable is there.

Is there any other option in resolving the path for [1] in the formula above?