[R] Re ad From EXCEL

[Petr PIKAL]

Hi

there is also a direct copy option

In Excel select a portion of data you want to copy, preferably with header 
and press Ctrl-C
Open R
issue

read.delim("clipboard")

For inverse transfer see

?write

Regards

Petr
petr.pikal at precheza.cz

r-help-bounces at r-project.org napsal dne 20.04.2008 17:51:26:

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