At proMENTE social research we often use the odfWeave and Sweave
packages for the amazing statistics program R for automating the
production of graphics and reports. odfWeave and Sweave are for the
OpenOffice and lyx (www.lyx.org) word processors respectively.
One problem with this approach arises when you have to produce and
insert into your document a whole bunch of graphics. For any other bunch
of things such as tables it is easy enough to make different kinds of
loops to produce the sets of tables you want. But graphics are a bit
more tricky because each graphic requires its own frame.
One way to do this which we have developed in odfWeave is to write a
loop to produce an intermediate source document which contains the code
for producing or inserting the actual graphics. Then you run odfWeave on
this intermediate document to produce the final document with the
graphics. So you do your weaving twice.
Assume you have a dataframe df of variables. Assume you have already
produced a folder full of graphics, named with the colnames of the
dataframe (if you have got this far, you are versed enough to know how
to do this already).
We will use the following function in the source document, source.odt,
to loop through the dataframe and produce an intermediate document
called intermediate.odt with one piece of odfInsertPlot code for each
graphic. Then the second odfWeave command produces the final document
This is the function you need to have defined previously
xodf.t=function(x) cat("<>=","n", "cat(odfInsertPlot('/path/to/file/",x,".png',externalFile=T))","n", "odfCat('some caption')","n", "@","n",sep="")
And this is the loop you need to put in the source.doc.
<>= for(x in colnames(df)) xodf.t(x) @
So you run odfWeave(“source.odt”,“intermediate.odt”) in R and then run
odfWeave(“intermediate.odt”,“final.odt”) again in R to produce your