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.
