[R] Write an Excel workbook?

Spencer Graves spencer.graves at structuremonitoring.com
Thu Jun 27 21:14:47 CEST 2013


Is there a fully transportable way to write an Excel workbook?

The "writeFindFn2xls" function in the "sos" package attempts to write 
search results to an Excel workbook consisting of (1) a summary of the 
packages identified in the search, (2) the individual help pages found, 
and (3) the search that produced 1 and 2. Unfortunately, for some time 
now, it only works with 32-bit R; the 64-bit R writes this information 
to three separate csv files.

The current code first tries WriteXLS{WriteXLS}. Unfortunately, this 
fails on my computer, because it can't find the Perl module 
"Text::CSV_XS". I don't see an easy fix to this.

If WriteXLS fails, the code then tries odbcConnectExcel{ODBC}. From 
this, I get, "odbcConnectExcel is only usable with 32-bit Windows". 
That's OK, but it means that I need to run all my searches on 32-bit R, 
and I usually use 64-bit R.

I tried write.xls{dataframes2xls}. This put quotes around everything, 
which I found unacceptable.

findFn('write.xls') identified a function by that name in the "marray" 
package. Unfortunately, install.packages("marray") produced, "Warning 
message: package ‘marray’ is not available (for R version 3.0.1)" 
"???xls" failed to produce anything else that looked to me like it would 
write a complete workbook.

Spencer Graves

 > sessionInfo()
R version 3.0.1 (2013-05-16)
Platform: x86_64-w64-mingw32/x64 (64-bit)

[1] LC_COLLATE=English_United States.1252
[2] LC_CTYPE=English_United States.1252
[3] LC_MONETARY=English_United States.1252
[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-6 WriteXLS_2.3.1 sos_1.3-7 brew_1.0-6

More information about the R-help mailing list