[R] RES: xlsReadWrite package repository for Ubuntu

Gabor Grothendieck ggrothendieck at gmail.com
Tue Mar 3 15:12:28 CET 2009


There is a recently updated review of the alternatives on the R Wiki:

http://wiki.r-project.org/rwiki/doku.php?id=tips:data-io:ms_windows

On Tue, Mar 3, 2009 at 9:00 AM, Marc Schwartz <marc_schwartz at comcast.net> wrote:
> 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.
>
> Regards,
>
> Marc
>
> 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
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>




More information about the R-help mailing list