[R] xlsReadWrite package repository for Ubuntu

[Marc Schwartz]

You perhaps missed the key point in Uwe's response, which is that the
package is only available under Windows, as it depends upon Windows
specific functionality (MS Office API via a third party library which is
available for Windows only) to natively read and write Excel files.
Thus, there is no package version available for Linux, or OSX for that
matter.

If you need to read Excel files under Linux, you could look at the
read.xls() function in the 'gdata' CRAN package. This package requires
that Perl be installed, as it calls a Perl routine (xls2csv) for
converting the Excel file to a CSV file, which can then be read into R.

If you need to write Excel files under Linux, you can use a Perl routine
that I had posted back in 2007:

  https://stat.ethz.ch/pipermail/r-help/2007-July/135968.html

and have updated since then to handle Unicode issues. I am attaching a
2k text file here with the updated routine.

HTH,

Marc Schwartz

on 03/03/2009 06:38 AM reverend33 wrote:
> I'm sorry, maybe i didn't explain clearly: i'm trying to install xlsReadWrite
> on a Linux-type OS (Ubuntu)...
> 
> 
> 
> 
> 
> Uwe Ligges-3 wrote:
>>
>>
>> reverend33 wrote:
>>> Hi,
>>>
>>> I'm trying to install R on Ubuntu.
>>> I succeeded at installing the r-recommended package that is present in
>>> the
>>> synaptics, but i can't find the xlsReadWrite package in the repositories
>>> included in my synaptics manager.
>>> Does anybody know a liable repository in which this package is present.
>> If you consider the CRAN master to be liable, it tells you for
>> xlsReadWrite:
>>
>> OS_type: 	windows
>>
>> Moreover it tells you that the package's status for R-devel is "ERROR".
>>
>>
>> Uwe Ligges
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: WriteXLS.txt
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20090303/6b545be9/attachment-0003.txt>