Exporting output from R into an open Excel workbook

Question

I've found the package XLConnect to be useful for exporting matrices to a CLOSED workbook, but does anyone know how to write to an OPEN workbook?

Alternatively, does anyone know of code one can write in VBA to import a matrix from an R script file?

Thanks

Mike

Answer 1

I've been wanting to do just this and stumbled upon excel.link that writes easily into an active excel sheet. The method to write is very simple and straightforward:

library(excel.link)
xlrc[a1] <- seq(1, 10) 

Note that inside the brackets you write the cell where the data will be written (if it is a dataframe, this cell will be the upper left of said dataframe).

Result in the active sheet of the active excel file:

Answer 2

Use package excel.link this can work with xlsm and also with open excels..