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 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.
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
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")
Get the latest release:
install.packages("devtools") library(devtools) devtools::install_github("tomwenseleers/export")
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)
The export package is licensed under the GPLv2.