Export pivot excel
Convert the dataset to an Excel file according to the structure currently displayed in the pivot and save it as a local file or upload it to the server.
The shape and data of the current pivot are exported to an external document according to the settings specified with the exportGtrid() function.
pivot.exportGrid({
target: "local",
fileName: "PivotExport.xlsx"
});