On Sun, May 20, 2012 at 8:30 AM, Gabor Grothendieck <ggrothendi...@gmail.com> wrote: > On Sat, May 19, 2012 at 9:32 PM, Spencer Graves > <spencer.gra...@structuremonitoring.com> wrote: >> Hello, All: >> >> >> The "writeFindFn2xls" function in the "sos" package tries to write an >> Excel file with 3 sheets ('PackageSum2', 'findFn', 'call'). Unfortunately, >> it is often unable to do this because of configuration problems that are not >> easy to fix. I've found 3 contributed packages that provide facilities to >> write Excel files with multiple sheets. Unfortunately, I can't get any of >> them to work consistently for me. Below please find test cases that >> illustrate the problems. Any suggestions for how to solve this problem will >> be appreciated. >> >> >> Thanks, >> Spencer >> >> >> library(dataframes2xls) >> >> df1 <- data.frame(c1=1:2, c2=3:4, c3=5:6) >> df2 <- data.frame(c21=c(10.10101010101,20, 3), c22=c(50E50,60, 3) ) >> outFile <- 'df12.xls' >> >> write.xls(c(df1,df2), outFile) >> # works >> >> do.call(write.xls, list(c(df1, df2), outFile)) >> # Error in get(s[i]) : object 'structure(list(c1=1:2' not found >> > > Try this: > > dd <- list(df1 = df1, df2 = df2) > do.call("WriteXLS", list("dd", outFile)) > > or this: > > do.call("WriteXLS", list(c("df1", "df2"), outFile) >
That was for WriteXLS. For dataframes2xls try this: do.call("write.xls", list(quote(c(df1, df2)), outFile)) and also check out this page: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.