[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 Window

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. http://cran.r-project.org

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, spencerg wrote: > Hello: > >     What should I do regarding code to write an Excel file in a non-Windows > platform?

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 P

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, wit

Re: [Rd] odbcConnectExcel on non-Windows?

2009-08-09 Thread Marc Schwartz
Hi Spencer, Unfortunately, the two Perl modules in question, Text::CSV_XS and Encode, are not pure Perl modules as they contain C code. This means that the modules need to be compiled either beforehand as a pre-packaged binary or during installation, both for the Perl version that is inst