CODEWITHSUNDEEP
excelr
Elizabeth
Elizabeth

Reputation: 6581

Exporting a matrix in R to an excel workbook

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?

Upvotes: 0

Views: 1680

Answers (2)

Mayank Raj
Mayank Raj

Reputation: 121

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)

Upvotes: 0

Beasterfield
Beasterfield

Reputation: 7123

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)

Upvotes: 4

Related Questions