[R] RES: xlsReadWrite package repository for Ubuntu

Marc Schwartz marc_schwartz at comcast.net
Tue Mar 3 15:00:37 CET 2009

That is fine if you only have one or two R objects to write out to CSV
files and then read them into Excel. It becomes rapidly tedious as the
number of objects increases.

If you go back and read my original post, the incentive for me to write
the Perl routine was that I had to create an Excel file for clients that
contained a "large" number of tabs, each tab containing data from an R
data frame. My clients are on Windows, I have been on Linux.

In many cases, the number of data frames was >20. Thus, creating that
number of CSV files, importing each one into a separate tab into a
single Excel and naming each tab appropriately (in my case, using
OO.org's Calc) became very tedious.

The Perl routing automates that process, saving a great deal of time and
reducing the potential for error.



on 03/03/2009 07:53 AM Leandro Marino wrote:
> I think in this case its better use the write.csv. Microsoft Excel reads csv files normally. 

> -----Mensagem original-----
> De: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] Em nome de Marc Schwartz
> Enviada em: terça-feira, 3 de março de 2009 10:38
> Para: reverend33
> Cc: r-help at r-project.org
> Assunto: Re: [R] xlsReadWrite package repository for Ubuntu
> 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

More information about the R-help mailing list