R, Excel, Function, Pivot Tables.
in R. The final step is easy: export diamond.wb to an Excel file on your computer (I put it under F drive for quick verification). saveWorkbook(diamond.wb, file = "F:/diamonds_summary.xlsx", overwrite = TRUE) The result is as follows: Another common scenario is to add a new table to an existing