[R] xls to csv conversion via WinXP's context menu?
ggrothendieck at gmail.com
Wed Sep 10 20:23:18 CEST 2008
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
> 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
>> 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
>> conversion, try ?xls2csv in gdata as well.
>> 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
>>> this by opening the file in excel and saving it as a csv. I would rather
>>> 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,
>>> R-help at r-project.org mailing list
>>> PLEASE do read the posting guide
>>> and provide commented, minimal, self-contained, reproducible code.
>> [[alternative HTML version deleted]]
>> R-help at r-project.org mailing list
>> PLEASE do read the posting guide
>> 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
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help