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
fails
under Linux and MacOS.
What would you suggest we do about this?
It currently tests (.Platform$OS.type == "windows"); if(FALSE),
it issues an error, saying that it only works under Windows. Also, the
help page skips those tests if the the platform is not Windows.
If there is a better way to handle this, I would like to know.
Thanks,
Spencer
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/web/packages/WriteXLS/index.html Portable (in the sense of used by Perl, Python, ... or other scripting engines) solutions have existed for a dozen years. We have a wrapper to Perl code for a long time too (having been of the initial discussions that lead to Greg's initial read.xls from the gdata package). Dirk -- Three out of two people have difficulties with fractions.
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<spencer.graves at prodsyse.com> wrote:> 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 fails under Linux and > MacOS. > > ? ? What would you suggest we do about this? > > ? ? It currently tests (.Platform$OS.type == "windows"); ?if(FALSE), it > issues an error, saying that it only works under Windows. ?Also, the help > page skips those tests if the the platform is not Windows. > > ? ? If there is a better way to handle this, I would like to know. > > ? ? Thanks, > ? ? Spencer > > ______________________________________________ > R-devel at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-devel >
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 suitable
> renaming of your function.
>
> On Sun, Aug 9, 2009 at 1:04 PM, spencerg<spencer.graves at
prodsyse.com> wrote:
>
>> 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 fails under
Linux and
>> MacOS.
>>
>> What would you suggest we do about this?
>>
>> It currently tests (.Platform$OS.type == "windows");
if(FALSE), it
>> issues an error, saying that it only works under Windows. Also, the
help
>> page skips those tests if the the platform is not Windows.
>>
>> If there is a better way to handle this, I would like to know.
>>
>> Thanks,
>> Spencer
>>
>> ______________________________________________
>> R-devel at r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-devel
>>
>>
>
>