From ggrothendieck at gmail.com  Sun Aug  9 19:22:13 2009
From: ggrothendieck at gmail.com (Gabor Grothendieck)
Date: Sun, 9 Aug 2009 13:22:13 -0400
Subject: [Rd] odbcConnectExcel on non-Windows?
In-Reply-To: <4A7F019C.9040804@prodsyse.com>
References: <4A7F019C.9040804@prodsyse.com>
Message-ID: <971536df0908091022j36e32232w420f70a01e728513@mail.gmail.com>

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
>



[Rd] odbcConnectExcel on non-Windows?
Gabor Grothendieck