formulas en xls don´t work with WriteWorksheet

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:

library(XLConnect)
requerido=c(50,25,30,50,60,60,80,83,72,65,66,67,45,30,30,30,34,23,24,25,25,14,14,17,17,8)
datos=data.frame(requerido)
wb <- loadWorkbook("C:/Eli compu/WFM_SLprueba.xlsx")
writeWorksheet(wb,datos, sheet="carga de requerido", startRow=2,startCol=8)
setForceFormulaRecalculation(wb,"*",TRUE)
saveWorkbook(wb)

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.