xls to csv conversion via WinXP's context menu?
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
<erich.neuwirth at univie.ac.at> 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 <mtb954 at gmail.com> 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 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.
[[alternative HTML version deleted]]
______________________________________________ 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.
-- 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 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.