Re: [R] Transfer Crosstable to Word-Document

From: Philippe Grosjean <phgrosjean_at_sciviews.org>
Date: Thu, 21 Feb 2008 11:40:40 +0100

bartjoosen wrote:
>
>
> Greg Snow-2 wrote:

>> ....
>>> write.table(my.data, 'clipboard', sep="\t")
>> Then in Excel just do a paste and the data is there, this saves a couple
>> of steps from saving as a .csv file and importing that into excel.  This
>> would probably be fine for a few tables.
>>
>> ....
>>

>
> Just to inform:
>
> if you use write.table(my.data,'whateverfile.xls',sep="\t", quote=FALSE),
> you can open this file right from the windows explorer as a normal excel
> file.
> If you're already running excel and choose file>open, you will get a dialog
> box, where you have to click complete or OK.
>
>
> Bart

Yes, but it is a very bad practice to name a file with .xls extension that is not in Excel file format (here, a tab-separated ASCII file)! Best,

Philippe Grosjean



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 Thu 21 Feb 2008 - 10:44:58 GMT

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 22 Feb 2008 - 13:30:16 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