On Thu, 6 Oct 2016, Blake Watson wrote:
That's just how Excel stores it for XLSX files. The link table provides
the mapping between those indexes and the names shown in Excel. When POI
hits one of those, it goes to the link table to find the name of the file,
then checks for a setup referenced workbook with that name to resolve
things with
​So, when POI sees the [1] how does it know that that should map to
"myspreadsheet.xlsx"? Because the setupReferenced​Workbooks map is
"name"->evaluator. I feel like not knowing this is the key to my confusion.
The name to ID mapping is stored in the ExternalLinksTable, which comes
from another xml file within the .xlsx bundle. That's what POI uses to
lookup the name, and what Excel transparently uses when displaying the
formula
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
