search

nacnudus / tidyxl

Read untidy Excel files in R https://nacnudus.github.io/tidyxl/
https://nacnudus.github.io/tidyxl/
Other
248 stars 21 forks source link

Formulas referring to other files #69

Open RavenCEF opened 3 years ago

RavenCEF commented 3 years ago

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 3 years ago

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 3 years ago

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)

navilis commented 1 month ago

I would be quite interested in the solution you offered: separate table of external references. As the thread is a couple years old, I was wondering if this function is already available only I did not notice.

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