Re: [R] Transfer Crosstable to Word-Document

From: Greg Snow <Greg.Snow_at_imail.org>
Date: Sat, 16 Feb 2008 20:44:41 -0700

If your final goal is a word document, then you should look at the odfWeave package.


From: r-help-bounces_at_r-project.org on behalf of ukoenig_at_med.uni-marburg.de Sent: Fri 2/15/2008 8:30 AM
To: r-help_at_r-project.org
Subject: [R] Transfer Crosstable to Word-Document

# 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



Udo Koenig
Clinic for child and adolescent psychiatry University of Marburg / Germany

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.

        [[alternative HTML version deleted]]



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 - 03:51:46 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 Sun 17 Feb 2008 - 18: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