poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Blake Watson <blake.wat...@pnmac.com>
Subject Re: Linking External Workbooks
Date Thu, 06 Oct 2016 21:32:43 GMT
Thanks again, Nick!

On Thu, Oct 6, 2016 at 11:12 AM, Nick Burch <apache@gagravarr.org> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>



-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com <melanie.petrosyan@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message