I have some excel file that contains various formulas. I would like to import the files in R, but before that I need to update their formulas.
Can I use xlsx (or another R package) in Rstudio to refresh the file before importing it? is that possible in R? I would like to avoid opening the file manually if possible.
thanks but what I am trying to do is pretty simple actually. I just want to refresh my worksheet before importing it in R. I need to refresh it because the excel file contains formulas.
I'm not sure if this would help but the RDCOMClient package allows you to to interact with Excel programmatically, maybe you could use it to trigger an update.