Hello, It is my first time in this community.
I am trying something very simple but it does not work. The formulas in excel do not update when excel receives the input from R studio via writeWorksheet.
I tried with setForceFormulaRecalculation but nothing happens. Here the code:
wb <- loadWorkbook("C:/Eli compu/WFM_SLprueba.xlsx")
writeWorksheet(wb,datos, sheet="carga de requerido", startRow=2,startCol=8)