From spencer.graves at prodsyse.com  Sun Aug  9 20:12:43 2009
From: spencer.graves at prodsyse.com (spencerg)
Date: Sun, 09 Aug 2009 13:12:43 -0500
Subject: [Rd] odbcConnectExcel on non-Windows?
In-Reply-To: <971536df0908091022j36e32232w420f70a01e728513@mail.gmail.com>
References: <4A7F019C.9040804@prodsyse.com>
	<971536df0908091022j36e32232w420f70a01e728513@mail.gmail.com>
Message-ID: <4A7F119B.1010404@prodsyse.com>

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



[Rd] odbcConnectExcel on non-Windows?
spencerg