[R] RES: xlsReadWrite package repository for Ubuntu

Leandro Marino leandro at cesgranrio.org.br
Tue Mar 3 14:53:00 CET 2009

I think in this case its better use the write.csv. Microsoft Excel reads csv files normally. 

Leandro Lins Marino
Centro de Avaliação
Rua Santa Alexandrina, 1011 - 2º andar
Rio de Janeiro, RJ - CEP: 20261-903
R (21) 2103-9600 R.:236 
( (21) 8777-7907
( leandro at cesgranrio.org.br

"Aquele que suporta o peso da sociedade
    é precisamente aquele que obtém
 as menores vantagens". (SMITH, Adam)

  Antes de imprimir pense em sua responsabilidade e compromisso com o MEIO AMBIENTE 

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


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


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