Re: [R] Re ad From EXCEL - Question

From: Bert Gunter <gunter.berton_at_gene.com>
Date: Mon, 21 Apr 2008 08:20:04 -0700

Erich:

Past posts on this list have pointed out various pros and cons of different methods of data transer to R from Excel, in particular, loss of precision, formatting problems, etc. Do you have any comments about to what degree any of these alternatives may be susceptible or immune from these difficulties?

-----Original Message-----
From: r-help-bounces_at_r-project.org [mailto:r-help-bounces_at_r-project.org] On Behalf Of Erich Neuwirth
Sent: Sunday, April 20, 2008 2:18 AM
To: r-help_at_r-project.org
Subject: Re: [R] Re ad From EXCEL

To transfer data from Excel to R you have a least 3 options. RODBC is platform-independent. You can use it to read Excel files on any platform where you have an ODBC driver for Excel installed.

xlsReadWrite is available only on Windows. It has a function read.xls which reads data from Excel worksheets into data frames or matrices. It does not need Excel installed.

RExcel (available through package RExcelInstaller on CRAN) needs Excel. Among other things, it allows you to select a range in Excel and transfer it into R through operations available on additional Excel menus. RExcel not only allows data transfer, it also allows you to use R function in Excel macros and even in Excel worksheet functions.

RExcel (and related software) has its own website at http://rcom.univie.ac.at. It also has its own mailing list which can be reached through this website.

ermimi wrote:
> Hello!!!
>
> I have been read a much about as read data from Excel File, but I havenīt
> found the necesary information to read the data.
> Now, I can create a channel : channel <- odbcConnectExcel("file.xls") but
I
> donīt know as read the data??
>
> I hope that you could help me. Thank you very much.

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

______________________________________________
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.
Received on Mon 21 Apr 2008 - 16:12:12 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 21 Apr 2008 - 16:30:30 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive