Search code examples
rlatexpowerpointsweave

Use R and Latex to Automate Powerpoint Reports

I have a report template that I use quite often. The analysis is completed in R, but at the moment here is my workflow:

  1. Use R to run the analysis and export the results to csv files
  2. Use excel macros to read in the data, manipulate chart/create tables
  3. Again using excel, "automate" the charts/tables to Powerpoint

The more I am exposed to Latex, R, and Reproducible Research, I feel like there should be a way to stay within R and send my results to Powerpoint. I know there is the R2PPT package, but I am trying to think of all options. I don't think sending pictures of my graphs will be an issue, it's more the table creation that has me stumped.

Any help you can provide will be greatly appreciated! Unforunately, yes, I need to continue to use PPT.

Solution

  • Can you automate PowerPoint from R? Ie, start it, get access to the object model, etc?

    If so, you should be able to create the tables directly within PPT.