Thanks again, Nick! On Thu, Oct 6, 2016 at 11:12 AM, Nick Burch <[email protected]> wrote:
> 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] > -- *Blake Watson* *PNMAC* Application Development Manager 5898 Condor Drive Moorpark, CA 93021 (805) 330.4911 x7742 [email protected] <[email protected]> www.PennyMacUSA.com <http://www.pennymacusa.com/>
