The main difference is that read.xls and xls2csv in the gdata package use a perl program which works on all platforms whereas the others require Windows but may have advantages there.
On Wed, Sep 10, 2008 at 1:40 PM, Erich Neuwirth <[EMAIL PROTECTED]> wrote: > There are at least 2 more packages which can handle the conversion. > > xlsReadWrite (only available on Windows) allows you to read Excel > files directly in R. At the moment xls, but not xlsx and xlsm, AFAIK. > > RExcel (available via RExcelInstaller on CRAN) > is an Excel addin which allows you to transfer > data between R and Excel from within Excel. > It works in Excel version 2002, 2003 and 2007, > so it also allows transfer of xlsx and xlsm files. > It does much more, e.g. it also allows you to call > R functions in spreadsheet cell formulas. > More information on rcom.univie.ac.at. > > Erich Neuwirth > > Footnote: > I am not connected with xlsReadWrite, and I am the author or RExcel. > > > > > Jorge Ivan Velez wrote: >> >> Dear Mark, >> I think you don't need to convert your xls files into csv files to read >> them >> using R. There are several ways to read them such as >> the RODBC package and ?read.xls in gdata. Now, if you really want to do >> the >> conversion, try ?xls2csv in gdata as well. >> >> HTH, >> >> Jorge >> >> >> >> On Fri, Sep 5, 2008 at 6:45 PM, Mark Na <[EMAIL PROTECTED]> wrote: >> >>> Frequently I need to convert a .xls to a .csv (for import into R) and I >>> do >>> this by opening the file in excel and saving it as a csv. I would rather >>> do >>> this using WinXP's context menu (right click the xls, choose "convert to >>> csv") but I don't know of a utility that does this. Any ideas? Thanks, >>> Mark >>> >>> ______________________________________________ >>> 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. >>> >> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> 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. >> >> > > -- > Erich Neuwirth, University of Vienna > Faculty of Computer Science > Computer Supported Didactics Working Group > Visit our SunSITE at http://sunsite.univie.ac.at > Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 > > ______________________________________________ > 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.