[R] Re ad From EXCEL

[Erich Neuwirth]

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