R & Excel: Creating Pivot Tables & Slicers

Question

Our business users would like us to create exports of the data behind our analyses. The AVP would like to know if we can throw a slicer on the data so the users can filter the data any way they want. Excel slicers are backed by pivot tables, so I'd have to be able to create a pivot table in the Excel workbook first.

I can easily export the data to Excel from R. I can't seem to find an R package that supports the creation of either pivot tables or slicers. Does such a package exist? Or is this simply beyond the scope of any available package at this time?

Answer 1

This is an old question, but in case somebody ends up here and still needs an answer to the core question:

I can easily export the data to Excel from R. I can't seem to find an R package that supports the creation of either pivot tables or slicers [in Excel]. Does such a package exist?

Yes, there is thanks to Chris Bailiss. Check out the package pivottabler, and there's a great vignette walk-through here.