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_schwa...@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-boun...@r-project.org [mailto:r-help-boun...@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@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@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. > ______________________________________________ R-help@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.
