poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <apa...@gagravarr.org>
Subject Re: Linking External Workbooks
Date Thu, 06 Oct 2016 18:12:55 GMT
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

Mime
View raw message