Re: [R] Transfer Crosstable to Word-Document

From: Marc Schwartz <marc_schwartz_at_comcast.net>
Date: Fri, 15 Feb 2008 11:17:22 -0600

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 support third party application functionality, though I am considering a future modification to enable LaTeX output to support Sweave functionality.

You are of course free to modify the source code for CrossTable() to fit your own requirements, which is the advantage of using an open source platform.

Regards,

Marc Schwartz

ukoenig_at_med.uni-marburg.de wrote:
> 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 better.
> I tried this with the view(....) (see below).
> Udo
>
>
>
> Quoting Gabor Grothendieck<ggrothendieck_at_gmail.com>:
>
>> 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 change the font of the
>> pasted text to Courier or other fixed space font and change its
>> size too if need be.
>>
>> On Fri, Feb 15, 2008 at 10:30 AM,<ukoenig_at_med.uni-marburg.de> 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 that table).
>>> # Annother idea was, to produce a TEX-file,
>>> # insert it and make it a word-table.
>>>
>>> # I found the following libraries, which seemed to be promising:
>>> # xtable
>>> # prettyR
>>> # R2HTML
>>> # Hmisc
>>> # SciViews / svViews
>>>
>>>
>>>
>>> #######################################################################
>>> ## My example: a crosstable (made with CrossTable from lib gmodels ####
>>> #######################################################################
>>>
>>> library(gmodels)
>>> library(xtable)
>>> library(svViews)
>>>
>>> # Data for crosstabulation
>>> set.seed(1)
>>> n<- 200
>>> sex<- sample(c("f","m"),n,T)
>>> state<- sample(c("AL","AK","CA"),n,T)
>>>
>>> #Create crosstab
>>> ct<- CrossTable(state, sex, expected=TRUE, format="SPSS", digits=1)
>>> ct #display crosstab on screen
>>>
>>> #Trie to produce a html file
>>> xtable(ct) #Error message: No method!
>>> methods(xtable)
>>>
>>>
>>>
>>> #Try to create a rich formatted table and insert it into Word
>>> #with svViws, but only a little part of crosstab it inserted
>>>
>>> docdir<- "r:\\r"
>>> WordOpen(file.path(docdir, "cross.doc"))
>>> viewfile<- view(ct, type = "summary", browse = FALSE)
>>> WordGoto("ctview")
>>> WordInsertFile(viewfile, TRUE) #only a little part of crosstab inserted
>>> WordActivate(async = TRUE)
>>>
>>>
>>> #How could I create the latex-code for the crosstable?
>>> w<- latex(ct) #would that work?
>>>
>>> # I could not test this, because I didnīt install Miktex yet
>>> # (I will do this soon)
>>>
>>> Can someone help me?
>>>
>>> Thanks in advance
>>> Udo
>>>



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 Fri 15 Feb 2008 - 17:26:47 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 Fri 15 Feb 2008 - 18:30:14 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