Excel Export

The PivotGridV2 provides built-in Excel export capabilities.

To use the Excel export feature, reference the JSZip library before the Kendo UI JavaScript files in the _Layout.cshtml. For more information, refer to the Excel export requirements.

General

To export the PivotGridV2, call the saveAsExcel() client-side API method of the component.

<script> function buttonClick() { var pivotgrid = $("#pivotgrid").data("kendoPivotGridV2"); pivotgrid.saveAsExcel(); } </script>

The PivotGridV2 also provides an Excel configuration that allows you to set additional options, such as the name of the generated file or the proxy URL.

 @(Html.Kendo().PivotGridV2() .Name("pivotgrid") .Excel(excel => excel .FileName("Kendo UI PivotGridV2 Export.xlsx") .Filterable(true) .ProxyURL(Url.Action("Excel_Export_Save", "Home")) ) //... Other configuration ... )

Next Steps

• Configuring the export to Excel
• Exporting the PivotGridV2 to Excel (demo)

See Also

• PDF Export by the PivotGridV2 HtmlHelper for ASP.NET MVC (Demo)
• Server-Side API