[R] Re ad From EXCEL

ermimi ermimi_ at hotmail.com
Sun Apr 20 17:51:26 CEST 2008


Thank you Erich for you information, I will continue investigating about as
read data from excel.

Erich Neuwirth wrote:
> 
> 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 en 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.
> 
> 

-- 
View this message in context: http://www.nabble.com/Read-From-EXCEL-tp16787900p16795064.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list