excel - Alternative for r2excel package in R 3.3.3 -
until happily using r2excel
package save multiple data sheets excel format using script:
library("r2excel") filename <- "r2excel-example1.xlsx" wb <- createworkbook(type="xlsx") sheet <- createsheet(wb, sheetname = "example1") xlsx.addtable(wb, sheet, head(iris), startcol=2) saveworkbook(wb, filename)
now have updated r version 3.3.3 package no longer available:
devtools::install_github("kassambara/r2excel") error in loadnamespace(name) : there no package called ‘curl’*
i have found difficult export files excel using other packages in old version. can recommend solution exporting multiple dataframes single excel file, compatible r3.3.3? (saving csv not option several reasons including need saving multiple sheets in 1 file).
thanks
Comments
Post a Comment