[R] xls to csv conversion via WinXP's context menu?

[Erich Neuwirth]

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