[R] Transfer Crosstable to Word-Document
David Scott
d.scott at auckland.ac.nz
Sat Feb 16 23:28:35 CET 2008
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
in the table (with a minor caveat below). The tables comprised results of
test with p-values and confidence intervals etc for various variables.
To produce the entries in the table I wrote a small function which pasted
bits of output together and formatted numbers exactly using formatC. Often
the function produced a number of cells at one time.
One difficulty I had was Excel deciding as usual that it knew better than
I did what I wanted. So when I had a cell with a p-value in brackets, that
was of course a negative number for example. My solution was to prepend a
' character which make Excel treat the following characters literally.
Once the table has been put in Word a simple search and replace can remove
the ' characters.
Overall, I was reasonably happy with the approach I took. If I have a
future need I will have some ready-made functions to work from which will
make life easier. I will be interested to try some of the other
suggestions in this thread.
David Scott
_________________________________________________________________
David Scott Department of Statistics, Tamaki Campus
The University of Auckland, PB 92019
Auckland 1142, NEW ZEALAND
Phone: +64 9 373 7599 ext 86830 Fax: +64 9 373 7000
Email: d.scott at auckland.ac.nz
Graduate Officer, Department of Statistics
Director of Consulting, Department of Statistics
More information about the R-help
mailing list