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
[EMAIL PROTECTED]
[EMAIL PROTECTED] 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@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@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@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.
