Re: [R] Transfer Crosstable to Word-Document

2008-02-22 Thread bartjoosen
I must admit it's a very bad practice, but if you put these files in a separate folder, and you know what you have been busy with, I think it's less important. At least it saves you some mouse clicks But Philippe, you are absolutely rigth about the bad practice! Bart Philippe Grosjean

Re: [R] Transfer Crosstable to Word-Document

2008-02-21 Thread Philippe Grosjean
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

Re: [R] Transfer Crosstable to Word-Document

2008-02-20 Thread bartjoosen
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

Re: [R] Transfer Crosstable to Word-Document

2008-02-20 Thread John Kane
I don't use Word much but an xtable (html) seems to import with no trouble. Thanks for reminding me that it works well with OOo. --- Peter Dalgaard [EMAIL PROTECTED] wrote: Gabor Grothendieck wrote: On Feb 16, 2008 5:28 PM, David Scott [EMAIL PROTECTED] wrote: On Sat, 16 Feb 2008,

Re: [R] Transfer Crosstable to Word-Document

2008-02-19 Thread Greg Snow
Center Intermountain Healthcare [EMAIL PROTECTED] (801) 408-8111 -Original Message- From: Udo König [mailto:[EMAIL PROTECTED] Sent: Sunday, February 17, 2008 11:08 AM To: r-help@r-project.org Cc: Greg Snow Subject: RE: [R] Transfer Crosstable to Word-Document Zitat von Greg

Re: [R] Transfer Crosstable to Word-Document

2008-02-19 Thread Udo König
, 2008 11:08 AM To: r-help@r-project.org Cc: Greg Snow Subject: RE: [R] Transfer Crosstable to Word-Document Zitat von Greg Snow [EMAIL PROTECTED]: If your final goal is a word document, then you should look at the odfWeave package. Greg, I had a look at the odfWeave package

Re: [R] Transfer Crosstable to Word-Document

2008-02-17 Thread Peter Dalgaard
Gabor Grothendieck wrote: On Feb 16, 2008 5:28 PM, David Scott [EMAIL PROTECTED] wrote: On Sat, 16 Feb 2008, Alan Zaslavsky wrote: If you want to get nicely formatted tables in Word and are familiar with Office tools (I know it's the Evil Empire but some of us work there), I

Re: [R] Transfer Crosstable to Word-Document

2008-02-17 Thread Tobias Sing
On Feb 17, 2008 2:49 PM, Udo König [EMAIL PROTECTED] wrote: [...] Greg: To the odfWeave package: in [2] I found the sentence The package is currently limited to creating text documents using OpenOffice. So it doesn´t seem work with MS-Word? Udo, I think odfWeave is exactly what you need

Re: [R] Transfer Crosstable to Word-Document

2008-02-17 Thread Gabor Grothendieck
On Feb 17, 2008 8:20 AM, Gabor Grothendieck [EMAIL PROTECTED] wrote: On Feb 17, 2008 4:41 AM, Peter Dalgaard [EMAIL PROTECTED] wrote: Gabor Grothendieck wrote: On Feb 16, 2008 5:28 PM, David Scott [EMAIL PROTECTED] wrote: On Sat, 16 Feb 2008, Alan Zaslavsky wrote: If you

Re: [R] Transfer Crosstable to Word-Document

2008-02-17 Thread Duncan Temple Lang
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You can programmatically create content directly in Word from R including tables, lists, paragraphs, etc. via a DCOM connection where R is the client and Word is the server. There are two packages to do this - rcom and RDCOMClient and both allow you

Re: [R] Transfer Crosstable to Word-Document

2008-02-17 Thread Udo König
Zitat von Greg Snow [EMAIL PROTECTED]: If your final goal is a word document, then you should look at the odfWeave package. Greg, I had a look at the odfWeave package, but it seems that complex tables, for instance produced with latex() can´t be produced/included, as can be done with

Re: [R] Transfer Crosstable to Word-Document

2008-02-16 Thread Jim Lemon
[EMAIL PROTECTED] wrote: # Dear list, # I am an R-beginner and # spent the last days looking for a method to insert tables produced # with R into a word document. I thought about SPPS: copy a table from # an SPO-file and paste it into a word document # (if needed do some formatting with

Re: [R] Transfer Crosstable to Word-Document

2008-02-16 Thread Gabor Grothendieck
Here is a partial solution. It still requires some manual intervention. # run this in R data(infert); attach(infert) Lines - capture.output(CrossTable(education, induced)) ix - grep( | , Lines, fixed = TRUE) writeLines(Lines[ix], clipboard) Now paste the clipboard into Word, select the table in

Re: [R] Transfer Crosstable to Word-Document

2008-02-16 Thread ukoenig
Hi, thank you very much for your comments and examples, which are very helpful! [I saw that the summary.formula (lib. Hmisc) has an option cross, which might be useful too...] Alan, I agree with you: at the workplace we have a Windows-XP network with MS-Office, so I have to cope with this; I will

Re: [R] Transfer Crosstable to Word-Document

2008-02-16 Thread David Scott
On Sat, 16 Feb 2008, Alan Zaslavsky wrote: If you want to get nicely formatted tables in Word and are familiar with Office tools (I know it's the Evil Empire but some of us work there), I suggest that you use Excel for formatting and then insert the table into your Word document. IMHO,

Re: [R] Transfer Crosstable to Word-Document

2008-02-16 Thread Gabor Grothendieck
On Feb 16, 2008 5:28 PM, David Scott [EMAIL PROTECTED] wrote: On Sat, 16 Feb 2008, Alan Zaslavsky wrote: If you want to get nicely formatted tables in Word and are familiar with Office tools (I know it's the Evil Empire but some of us work there), I suggest that you use Excel for

Re: [R] Transfer Crosstable to Word-Document

2008-02-16 Thread Greg Snow
If your final goal is a word document, then you should look at the odfWeave package. From: [EMAIL PROTECTED] on behalf of [EMAIL PROTECTED] Sent: Fri 2/15/2008 8:30 AM To: r-help@r-project.org Subject: [R] Transfer Crosstable to Word-Document # Dear list, # I

[R] Transfer Crosstable to Word-Document (2. attempt)

2008-02-15 Thread ukoenig
# Dear list, # I am an R-beginner and # spent the last days looking for a method to insert tables produced # with R into a word document. I thought about SPPS: copy a table from # an SPO-file and paste it into a word document # (if needed do some formatting with that table). # Annother idea was,

Re: [R] Transfer Crosstable to Word-Document

2008-02-15 Thread Gabor Grothendieck
Here are 2 ways: 1. Display it on the screen and hit the PrintScreen button. Then paste that into Word and use Word's image editor to crop it and expand or shrink it appropriately. 2. Run this in R: capture.output(CrossTable(...whatever...), file = clipboard) Paste the clipboard into Word and

Re: [R] Transfer Crosstable to Word-Document

2008-02-15 Thread ukoenig
Thank you Gabor, but with 1. or 2. I don´t get a table, which can be changed and formatted using the WORD table functions (like changing column width and formatting text in rows). The result of 1. ist an bitmap and the result of 2. an ASCII-Table A rich formatted (*.rtf) table/object would be

Re: [R] Transfer Crosstable to Word-Document

2008-02-15 Thread Don MacQueen
I usually use the write.table() function (with tab as the delimiter) to write to a text file, then copy/paste into Word, then use Word's convert text to table command. Obviously, if one needs to do this for many, many, tables, the amount of manual manipulation is excessive. That's when

Re: [R] Transfer Crosstable to Word-Document

2008-02-15 Thread Gabor Grothendieck
In that case you shouldn't be using CrossTable in the first place. Suggest you look into the functions mentioned under See Also in ?CrossTable or look at the source of CrossTable and modify it for your purposes. On Fri, Feb 15, 2008 at 11:52 AM, [EMAIL PROTECTED] wrote: Thank you Gabor, but

Re: [R] Transfer Crosstable to Word-Document

2008-02-15 Thread Marc Schwartz
Udo, CrossTable() knows nothing about the proprietary formats of Word tables. The output is designed for the R console, using a fixed width (monospace) font. The cell boundaries are drawn using standard ASCII characters. There are no plans at present to modify the format of the output to