Excel Export
The built-in export functionality of the PivotGrid allows you to share and distribute data in Excel.
Basics
The PivotGrid enables you to export data to MS Excel and provides client Excel-export functionality which is server-agnostic and which can be directly utilized to share data offline. To trigger the export to Excel, invoke the saveAsExcel
method of the PivotGrid. In order for the Excel export to work, add a reference to the jszip
library on the page by either using NPM and assigning the global window.JSZip
variable or by adding the script from CDN with the code.