Reputation: 1
I want to make a pivot using R, set pivot table fields and export to Excel as formatted pivot table. Is there any package that allows me to do this? Maybe it is possible to first set a pivot table with excel and then use R to read and export other tables?
Upvotes: -1
Views: 263
Reputation: 26
There are many packages that help you make pivot tables, the most popular are Tidyr
from Tidyverse
and data.table
, and to export to Excel you can use XLConnect
or openxlsx
. Maybe if you provide some reproducible example someone around here could help you.
Upvotes: 0