将数据从R导出到EXCEL:公式不会重新计算
wb <- loadWorkbook("测试.xlsx")
i=15
writeData(wb, sheet = "2022年", i,
startCol = 5, startRow = 8, colNames = FALSE)
saveWorkbook(wb, "测试.xlsx", overwrite = TRUE)
k=read.xlsx(wb, sheet = "2023年", cols = 5, rows = 8)