We have developed a Web UI using Shiny R and deployed using RStudio COnnect.
I am having issue in refreshing excel formula.
Here is my use case
I upload excel file with formula into server using RScript and my another R function which connects into My SQL and extract data from table and load into one of the sheet (Input sheet) in Saved excel file. I have formula written in another sheet (control sheet) which is referring Input sheet.
If data is getting updated in Input sheet, new value is not getting reflect in Control Sheet. When I tried to used readxl package to read excel file , I am getting old value not the new one. Basically formula is not refreshing to populate the new value.
Can someone please help me on this.
Thanks!