Exporting a matrix in R to an excel workbook

Question

I have several matrices in R and would like to export them as separate sheets to an existing workbook. Any ideas on how to go about this?

Answer 1

Have a look at the XLConnect library:

d <- matrix( rnorm(1000), ncol = 10 )

require(XLConnect)
wb <- loadWorkbook( "wb.xlsx", create=FALSE )
createSheet(wb, name="sheet1")
writeWorksheet( wb, as.data.frame(d), sheet="sheet1" )
saveWorkbook(wb)

Answer 2

require(XLConnect)
wb <- loadWorkbook( "wb.xls", create=TRUE )
createSheet(wb, name="sheet1")
writeWorksheet( wb,as.data.frame(A), sheet="sheet1" )
Error: IllegalArgumentException (Java): Sheet index (0) is out of range (0..-1)
saveWorkbook(wb)