Exporting a matrix in R to an Excel workbook

Question

I have several matrices in R and you want to export them as separate sheets to an existing book. Any ideas on how to do this?

Answer 1

Take 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)