Re: [R] Transfer Crosstable to Word-Document

From: Peter Dalgaard <p.dalgaard_at_biostat.ku.dk>
Date: Sun, 17 Feb 2008 10:41:50 +0100

Gabor Grothendieck wrote:

> On Feb 16, 2008 5:28 PM, David Scott <d.scott_at_auckland.ac.nz> 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 formatting and then insert the table into
>>> your Word document. IMHO, Excel is much superior to Word for table
>>> formatting, e.g. modifying number of significant digits, playing around
>>> with fonts and number formats, etc. And when you have gotten the formats
>>> right you can paste in modified values of the numbers in the table without
>>> having to do the formatting again. Including the table in your Word
>>> document is easy by cut-paste or creating a live link.
>>>
>>> As a user of R under Unix I haven't looked into the facilities for writing
>>> tables to Excel under Windows but there is something there. Alternatively
>>> you can write a fixed-column or tab-delimited file and easily import to
>>> Excel.
>>>
>>>
>> Production of tables and formatting them in Word is something I have dealt
>> with a couple of times recently and it really is important to do something
>> smart because of the time taken to individually format tables.
>>
>> An approach I used recently was to produce a text table in R and export it
>> to Excel as a .csv file which could then be copied as is to Word. Borders
>> and the like would still have to be formatted individually but not entries
>>
>
> You could get a border automatically by writing your table out
> as HTML.  Try this using the builtin data frame iris:
>
> library(R2HTML)
> HTML(iris, border = 1, file("clipboard","w"), append=FALSE)
>
> Now paste that into Excel and from Excel into Word and you should
> have a border around it.
>
> See ?HTML.data.frame
>
> You could alternately generate the HTML yourself giving quite a bit
> of control.
>   

Just curious (I don't use Word if I can help it -- even the simplest of things drive me up the wall), but can you not import HTML directly in Word? OpenOffice seems to do it quite happily with xtable output.
-- 
   O__  ---- Peter Dalgaard             ุster Farimagsgade 5, Entr.B
  c/ /'_ --- Dept. of Biostatistics     PO Box 2099, 1014 Cph. K
 (*) \(*) -- University of Copenhagen   Denmark          Ph:  (+45) 35327918
~~~~~~~~~~ - (p.dalgaard_at_biostat.ku.dk)                  FAX: (+45) 35327907

______________________________________________
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 Sun 17 Feb 2008 - 09:45:03 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 Wed 20 Feb 2008 - 16:30:15 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