[Rd] odbcConnectExcel on non-Windows?

spencerg spencer.graves at prodsyse.com
Sun Aug 9 20:12:43 CEST 2009


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



More information about the R-devel mailing list