R(3.0.2) / MSOffice 2013 / Win7
Assume we have an existing data.xlsx file with two sheets - "data" and "calc".
"data" sheet is filled through R with:
df <- data.frame(c(1,2,3,4,5), c(2,3,4,5,6))
wb <- loadWorkbook("data.xlsx", create=F)
writeWorksheet(wb, data=df, sheet="data", startRow=1, startCol=1, header=F)
Looking that this link gets some clicks and solution is hidden in comments section, here's the answer:
This should work for most of packages (at least ones based on rJava) as this java method is passed within excel, hence is not determined by R language.