Streamlined Export of Graphs and Data Tables

Easily export 'R' graphs and statistical output to 'Microsoft Office' / 'LibreOffice', 'Latex' and 'HTML' Documents, using sensible defaults that result in publication-quality output with simple, straightforward commands. Output to 'Microsoft Office' is in editable 'DrawingML' vector format for graphs, and can use corporate template documents for styling. This enables the production of standardized reports and also allows for manual tidy-up of the layout of 'R' graphs in 'Powerpoint' before final publication. Export of graphs is flexible, and functions enable the currently showing R graph or the currently showing 'R' stats object to be exported, but also allow the graphical or tabular output to be passed as objects. The package relies on package 'officer' for export to 'Office' documents,and output files are also fully compatible with 'LibreOffice'. Base 'R', 'ggplot2' and 'lattice' plots are supported, as well as a wide variety of 'R' stats objects, via wrappers to xtable(), broom::tidy() and stargazer(), including aov(), lm(), glm(), lme(), glmnet() and coxph() as well as matrices and data frames and many more...


export version 0.2.2 Beta

export is an R package to easily export active R graphs and statistical output in publication quality to Microsoft Office (Word, PowerPoint and Excel), HTML and Latex.

Useful links:

  • Report a bug: Bug report. If you report a bug, try to send a reproducible example and don't forget to send the result of

      sessionInfo()
    

Features

  • Save active R graphs or ggplot2, lattice or base R plots in publication quality to Microsoft Word, Powerpoint, or various other bitmap or vector formats using a single command with sensible defaults.
  • Fully editable Powerpoint vector format output, enabling manual tidy-up of plot layout.
  • Save the output of statistical analysis in R as tables in Excel, Word, PowerPoint, Latex or HTML documents.
  • Customize formatting of R outputs.

Installation

export needs some R packages ; run the following script to install them if needed.

install.packages("officer")
install.packages("rvg")
install.packages("openxlsx")
install.packages("ggplot2")
install.packages("flextable")
install.packages("xtable")
install.packages("rgl")
install.packages("stargazer")
install.packages("tikzDevice")
install.packages("xml2")
install.packages("broom")

Github

Get the latest release:

install.packages("devtools")
library(devtools)
devtools::install_github("tomwenseleers/export")

Getting Started

library(export)
   
?graph2ppt
?graph2doc
?graph2svg
?graph2png
?table2ppt
?table2tex
?table2excel
?table2doc
?table2html

## export of ggplot2 plot
library(ggplot2)
qplot(Sepal.Length, Petal.Length, data = iris, color = Species, 
      size = Petal.Width, alpha = I(0.7))
# export to Powerpoint      
graph2ppt()      
graph2ppt(file="ggplot2_plot.pptx", aspectr=1.7)
# add 2nd slide with same graph 9 inches wide and A4 aspect ratio
graph2ppt(file="ggplot2_plot.pptx", width=9, aspectr=sqrt(2), append=TRUE) 
# add 3d slide with same graph with fixed width & height
graph2ppt(file="ggplot2_plot.pptx", width=6, height=5, append=TRUE) 
# export to Word
graph2doc()
# export to bitmap or vector formats
graph2svg()
graph2png()
graph2tif()
graph2jpg()

## export of aov Anova output
fit=aov(yield ~ block + N * P + K, npk)
x=summary(fit)
# export to Powerpoint
table2ppt(x=x)
table2ppt(x=x,file="table_aov.pptx")
table2ppt(x=x,file="table_aov.pptx",digits=4,append=TRUE)
table2ppt(x=x,file="table_aov.pptx",digits=4,digitspvals=1,
          font="Times New Roman",pointsize=16,append=TRUE)
# export to Word
table2doc(x=x)
# export to Excel
table2excel(x=x, file = "table_aov.xlsx",digits=4,digitspvals=1,
            sheetName = "Anova_table", add.rownames = TRUE)
# export to Latex
table2tex(x=x)
# export to HTML
table2html(x=x)

License

The export package is licensed under the GPLv2.

News

export 0.2.2 Beta

New features

  • Made export use officer and flextable rather than ReporteRs and rtable, as the two latter were removed from CRAN.
  • Created table2spreadsheet() to generate table in a Microsoft Excel / LibreOffice Calc file or in a CSV (using either comma or semicolon as separation)
  • table2spreadsheet() and table2office() use the "broom" package additionaly to the "xtable" package which allows for more data classes to be exported as tables

Removed features

  • Removed graph2tex() as it is better to use graph2bitmap or graph2pdf and to manually insert these in the LaTex document

export 0.2.1 Beta

New features

  • Created table2office() to generate tables in a presentation (Microsoft PowerPoint or LibreOffice) or in a document (Microsoft Word or LibreOffice) with similar behavior as graph2office().

export 0.2.0 Beta

New features

  • Automatic selection of paper size based on graph size in MS Office export
  • Added Latex export of graphs & tables

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("export")

0.2.2 by Tom Wenseleers, 19 days ago


Report a bug at https://github.com/tomwenseleers/export/issues


Browse source code at https://github.com/cran/export


Authors: Tom Wenseleers [aut, cre] , Christophe Vanderaa [aut]


Documentation:   PDF Manual  


GPL-2 license


Imports stats, utils, datasets, grDevices, officer, rvg, xtable, flextable, rgl, xml2, stargazer, openxlsx, broom

Suggests ggplot2


See at CRAN