[R] RES: Excel to R

From: Filipe Leme Botelho <filipe.botelho_at_vpar.com.br>
Date: Fri, 13 May 2011 14:18:13 -0300

attached mail follows:


Why not using Statconn/RExcel?

-----Mensagem original-----
De: r-help-bounces_at_r-project.org [mailto:r-help-bounces_at_r-project.org] Em nome de Robert Baer
Enviada em: sexta-feira, 13 de maio de 2011 09:33 Para: Asan Ramzan; r-help_at_r-project.org
Assunto: Re: [R] Excel to R



From: "Asan Ramzan" <asanramzan_at_yahoo.com> Sent: Friday, May 13, 2011 6:02 AM
To: <r-help_at_r-project.org>
Subject: [R] Excel to R

> Hello R-help
>
> I am trying to copy and paste large column of data from windows Excel
into
> R
> base speed sheet using:
>
>
> Data1<-edit(data.frame())
At least on Windows (not sure about other OS's, you can paste data as follows:
Data1 <- read.table(file = 'clipboard', header = TRUE) # assuming you
have column labels
>
> But I can only copy and paste one cell at a time which is time
consuming.
>
> Also how can assign each column to a variable.
> [[alternative HTML version deleted]]
> ______________________________________________
> 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.

At least on Windows (not sure about other OS's



Robert W. Baer, Ph.D.
Professor of Physiology
Kirksville College of Osteopathic Medicine A. T. Still University of Health Sciences 800 W. Jefferson St.
Kirksville, MO 63501
660-626-2322
FAX 660-626-2965

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.

"This message and its attachments may contain confidential and/or privileged information. If you are not the addressee, please, advise the sender immediately by replying to the e-mail and delete this message."

"Este mensaje y sus anexos pueden contener información confidencial o privilegiada. Si ha recibido este e-mail por error por favor bórrelo y envíe un mensaje al remitente."

"Esta mensagem e seus anexos podem conter informação confidencial ou privilegiada. Caso não seja o destinatário, solicitamos a imediata notificação ao remetente e exclusão da mensagem."



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 Fri 13 May 2011 - 17:46:46 GMT

This quarter's messages: by month, or sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

All messages

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 Fri 13 May 2011 - 18:30:07 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