This project is read-only.

Resolve filename for external links in formulas - ExternalLinksTable

Apr 25, 2016 at 6: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.

This seems to be in POI, but I've been unsuccessful using this with NPOI.
Apr 25, 2016 at 7: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?