[Rd] odbcConnectExcel on non-Windows?

2009-08-09 Thread spencerg
Hello: What should I do regarding code to write an Excel file in a non-Windows platform? The sos package [new version of RSiteSearch] on R-Forge includes writeFindFn2xls, which starts with require(RODBC). The next line calls odbcConnectExcel. This works under Windows but

Re: [Rd] odbcConnectExcel on non-Windows?

2009-08-09 Thread Dirk Eddelbuettel
On 9 August 2009 at 12:04, spencerg wrote: | What should I do regarding code to write an Excel file in a | non-Windows platform? [...] | What would you suggest we do about this? [...] | If there is a better way to handle this, I would like to know.

Re: [Rd] odbcConnectExcel on non-Windows?

2009-08-09 Thread Gabor Grothendieck
Instead of writing out an xls file you could write out a file in any format that Excel can read, e.g. csv, with a suitable renaming of your function. On Sun, Aug 9, 2009 at 1:04 PM, spencergspencer.gra...@prodsyse.com wrote: Hello:     What should I do regarding code to write an Excel file in

Re: [Rd] odbcConnectExcel on non-Windows?

2009-08-09 Thread spencerg
Dear Marc: In spite of your efforts to help me, I still get an F in your WriteXLS class. Consider the following: library(WriteXLS) help(pac=WriteXLS) testPerl() Perl found. The following Perl modules were not found on this system: Text::CSV_XS If you have more than one Perl

Re: [Rd] odbcConnectExcel on non-Windows?

2009-08-09 Thread spencerg
Dear Gabor: Good suggestion. I will probably do that if WriteXLS is not installed or if it is but testPerl() is FALSE. Thanks, Spencer Gabor Grothendieck wrote: Instead of writing out an xls file you could write out a file in any format that Excel can read, e.g. csv, with a