Re: [R] Transfer Crosstable to Word-Document

From: John Kane <jrkrideau_at_yahoo.ca>
Date: Wed, 20 Feb 2008 10:38:00 -0500 (EST)


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.

> 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.
>



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 Wed 20 Feb 2008 - 15:43:01 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 - 17: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