nacnudus/tidyxl

Formulas referring to other files

RavenCEF opened this issue · 3 comments

RavenCEF commented

Forgive my noobyness... the readme refers to "the roadmap for tidyxl includes de-referencing such numbers". I'm struggling to understand where the "roadmap" is in the github documents. I'm working on parsing all formulas in a very large workbook as part of an automation project and was hoping there was a way to access a table with these indexed links "example [1]" that exit in my formulas. I've created a macro in Excel to pull those links, but I have to manually reference them with the index numbers provided in the xlsx_cells data. Wondering if this is something still in dev or completed and I'm just missing it. Thanks so much.

nacnudus commented

Sorry, there's no separate roadmap document. Nevertheless, I did intend to provide those tables once someone needed it.

Would it be sufficient for your purposes to have a separate table of external references, but not to put these inline into the formula? E.g. the formula would still appear as =[1]Sheet1!$A$1, but you could look up a table with the columns id and path.

Note to self: ECMA-376 Part 1, page 2052

Chuck-Field commented

So sorry for the slow response. I thought I would get an email notice that the issue was commented on. over the last few weeks I developed my own crude way of reading in the true file names from the index. I solved my problem, in other words.

I would share my code, if I thought it would actually prove useful... but a little shy about that.

I think a separate index reference table would be fine, to answer your question. (That's exactly what I created)