On 5/19/2012 7:59 PM, Jim Holtman wrote:
I have been using XLConnect to write multisheet Excel without any problems.
Thanks very much. That looks like it will solve my problems.
Best Wishes,
Spencer
p.s. findFn{sos} identified thatt for me, but for some unknown reason,
I overlooked it. I'll study it more carefully now.
Sent from my iPad
On May 19, 2012, at 21:32, 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
library(WriteXLS)
testPerl()
#Perl found.
#The following Perl modules were not found on this system:
#Text::CSV_XS
#If you have more than one Perl installation, be sure the correct one was used
here.
#Otherwise, please install the missing modules. See the package INSTALL file
for more information.
# *** NOTE: I may be able to fix this for myself.
# *** However, I want to use this in the 'sos' package,
# *** and if it doesn't work easily for me, it may not work for others.
library(RODBC)
xlsFile<- odbcConnectExcel(outFile, readOnly=FALSE)
# NOTE: This works with R 2.15.0 32-bit.
# However, with 64-bit, I get the following error message here:
# Error in odbcConnectExcel(outFile, readOnly = FALSE) :
# odbcConnectExcel is only usable with 32-bit Windows
# When this works, the following 3 lines of code
# suffice to create the outFile:
sqlSave(xlsFile, df1, tablename='sheet1')
sqlSave(xlsFile, df2, tablename='sheet2')
odbcClose(xlsFile)
sessionInfo()
#R version 2.15.0 (2012-03-30)
#Platform: x86_64-pc-mingw32/x64 (64-bit)
#locale:
#[1] LC_COLLATE=English_United States.1252
#[2] LC_CTYPE=English_United States.1252
#[3] LC_MONETARY=English_United States.1252
#[4] LC_NUMERIC=C
#[5] LC_TIME=English_United States.1252
#attached base packages:
#[1] stats graphics grDevices utils datasets methods base
#other attached packages:
#[1] RODBC_1.3-5 WriteXLS_2.1.0 dataframes2xls_0.4.5
______________________________________________
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.
