From: Petr Pikal <petr.pikal_at_precheza.cz>

Date: Fri 30 Sep 2005 - 01:29:55 EST

R-help@stat.math.ethz.ch mailing list

https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Fri Sep 30 01:34:05 2005

Date: Fri 30 Sep 2005 - 01:29:55 EST

Hi

Works for me.

write.excel <- function (tab, ...) write.table(tab, "clipboard", sep = "\t", row.names = F)

write.excel(a)

from your example shows in Excel after ctrl-V as a table with names.

**HTH
**
Petr

On 29 Sep 2005 at 12:12, Jose Quesada wrote:

Date sent: Thu, 29 Sep 2005 12:12:00 +0100 From: Jose Quesada <quesada@gmail.com> To: Werner Wernersen <pensterfuzzer@yahoo.de> Copies to: r-help@stat.math.ethz.ch Subject: Re: [R] Easy cut & paste from Excel to R? Send reply to: Jose Quesada <quesada@gmail.com> <mailto:r-help-request@stat.math.ethz.ch?subject=unsubscribe> <mailto:r-help-request@stat.math.ethz.ch?subject=subscribe>

> Sorry to revive and old topic, but writing to the clipboard seems to

*> have a problem for me: column names are ignored. Example:
**>
**> # ~~~~~~~~~~~~~~~~~~~~~~~
**> # write.clipboard
**> # ~~~~~~~~~~~~~~~~~~~~~~~
**> write.clipboard = function(obj) {
**> write.table(obj, file("clipboard"), sep="\t", row.names=F,
**> col.names=T)
**> }
**>
**> a= matrix(1:4,2,2)
**> colnames(a) = c("a", "b")
**>
**> write.clipboard(a)
**> a = as.data.frame(a)
**> write.clipboard(a)
**>
**> both attempts will paste the date without column names.
**> Any idea why?
**>
**> Thanks,
**> -Jose
**>
**> On 2/16/05, Werner Wernersen <pensterfuzzer@yahoo.de> wrote:
**> > Thank you all very much for the answers!
**> > The read.table / read.delim2 commands are exactly what
**> > I was looking for to get
**> > a couple of numbers or a little matrix quickly into R
**> > without creating an extra
**> > text file every time.
**> >
**> > And it works the other way around as well:
**> > write.table(x, file("clipboard"), sep="\t")
**> > Fantastic!
**> >
**> > Thanks again,
**> > Werner
**> >
**> > Nick Drew wrote:
**> > > I've had good luck with the scan() function when I
**> > > want to get a few numbers from Excel into R quickly
**> > to
**> > > use it as a calculator. CAVEAT: you have to have the
**> > > numbers you want to copy in a column not a row in
**> > > Excel. For example:
**> > >
**> > > In Excel your data are in a column as follows:
**> > > Col A
**> > > 1
**> > > 2
**> > > 3
**> > >
**> > > Then copy the 3 cells (e.g. 1, 2,3) in Excel and
**> > open
**> > > R and type in:
**> > >
**> > >>data <- scan()
**> > >
**> > >
**> > > Then Paste using Ctrl-V. Hit the Enter key. You know
**> > > have an object called "data" that you can use and
**> > > manipulate in R.
**> > >
**> > > I've taken this even further by creating an R
**> > function
**> > > that will take a column of numbers from Excel and
**> > then
**> > > scan() them into R, create a matrix, and then
**> > perform
**> > > a Chi-square test. Let me know if you'd like to know
**> > > more. I'm a beginner and if I can do so can you!!
**> > >
**> > > ~Nick
**> > >
**> > >
**> > >
**> > >
**> > > __________________________________
**> > > Do you Yahoo!?
**> >
**> >
**> > > http://promotions.yahoo.com/new_mail
**> > >
**> > >
**> >
**> > ______________________________________________
**> > R-help@stat.math.ethz.ch mailing list
**> > https://stat.ethz.ch/mailman/listinfo/r-help
**> > PLEASE do read the posting guide!
**> > http://www.R-project.org/posting-guide.html
**> >
**>
**>
**> --
**> Jose Quesada, PhD.
**>
**> j.quesada@warwick.ac.uk ESRC Postdoctoral Fellow
**> http://lsa.colorado.edu/~quesadaj Dept. of PSychology
**> http://www.andrew.cmu.edu/~jquesada University of Warwick
**> office H114 Phone: +44 024 765 23 759
**> Coventry, UK
**>
**> ______________________________________________
**> R-help@stat.math.ethz.ch 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

petr.pikal@precheza.cz

R-help@stat.math.ethz.ch mailing list

https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Fri Sep 30 01:34:05 2005

*
This archive was generated by hypermail 2.1.8
: Fri 03 Mar 2006 - 03:40:29 EST
*