Richard Hill and Andy Merlino show how you can export data from a Shiny app into Excel:
R is great for report generation. Shiny allows us to easily create web apps that generate a variety of reports with R.
This post details a demo Shiny app that generates an Excel report, a PowerPoint report, and a PDF report:
The full Shiny app source code is available here. Also, we included a more basic Shiny app that generates an Excel report at the end of this post. Follow up posts will include similar simple Shiny apps generating PowerPoint and PDF reports.
Excel is still the most popular business intelligence tool and Excel support tends to be one of the first requests people get with third-party apps, so it’s good to know you can do this in Shiny without too much rigmarole.