[R] Transfer Crosstable to Word-Document
Peter Dalgaard
p.dalgaard at biostat.ku.dk
Sun Feb 17 10:41:50 CET 2008
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
More information about the R-help
mailing list