将R中的矩阵导出到excel工作簿 [英] Exporting a matrix in R to an excel workbook
本文介绍了将R中的矩阵导出到excel工作簿的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
解决方案
看看 XLConnect 库:
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)
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?
解决方案
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)
这篇关于将R中的矩阵导出到excel工作簿的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文