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

[Gabor Grothendieck]

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.
>