If you do not want to use csv file transfer you can:
Open Excel
select data
Ctrl-C
Open R
your.data <- read.delim("clipboard")
will transfer clipboard contents of clipboard into your.data.
HTH
Petr
On 21 Feb 2006 at 8:52, Carl Klarner wrote:
Date sent: Tue, 21 Feb 2006 08:52:04 -0500
From: "Carl Klarner" <[EMAIL PROTECTED]>
To: <[email protected]>
Subject: [R] How to Import Data
> Hello,
> I am a very new user of R. I've spent several hours trying to import
> data, so I feel okay asking the list for help. I had an Excel file,
> then I turned it into a "csv" file, as instructed by directions. My
> filename is "x111.csv." I then used the following commands to read
> this (fairly small) dataset in.
>
> x111 <-read.table(file='x111.csv',
> sep="",header=T,
> quote="",comment.char="",as.is=T)
>
> I then get the following error message.
>
> Error in file(file, "r") : unable to open connection
> In addition: Warning message:
> cannot open file 'x111.csv', reason 'No such file or directory'
>
> I would imagine I'm not putting my csv file in the right location for
> R to be able to read it. If that's the case, where should I put it?
> Or is there something else I need to do to it first? Thanks for your
> help, Carl
>
> ______________________________________________
> [email protected] mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html
Petr Pikal
[EMAIL PROTECTED]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
