New to Telerik UI for ASP.NET MVC? Download free 30-day trial

ASP.NET MVC PivotGrid Excel Export

Loading Demo...
  • EXAMPLE
  • VIEW SOURCE
  • Change Theme
    default
    Default Theme
    • Main
    • Main Dark
    • Nordic
    • Ocean Blue
    • Ocean Blue A11Y accessibility
    • Purple
    • Turquoise
    Bootstrap Theme
    • Main
    • Bootstrap 3
    • Bootstrap 3 Dark
    • Main Dark
    • Nordic
    • Turquoise
    • Turquoise Dark
    • Urban
    • Vintage
    Material Theme
    • Main
    • Arctic
    • Lime Dark
    • Main Dark
    • Nova
    Classic Theme
    • Main
    • Green
    • Green Dark
    • Lavender
    • Lavender Dark
    • Main Dark
    • Metro
    • Metro Dark
    • Moonlight
    • Opal
    • Opal Dark
    • Silver
    • Silver Dark
    • Uniform
    Fluent Theme
    • Main
    Launch Theme Builder
excel_export.cshtml
Excel_ExportController.cs

Also available for:

CLIENT-SIDE API SERVER-SIDE API

Description

The Telerik UI for ASP.NET MVC PivotGrid control allows you to export its content to Excel by using the filtering applied by the user. For greater control over the output, configure the Export() export configuration method. For instance, you can specify the file name and whether to export all pages, margins, paper size, font, and so on.

The current example shows how to enable the export functionality for the PivotGrid through an external button, which, upon clicking, utilizes the client-side saveAsExcel() method while passing the explicitly defined Excel configurations set through the Excel() configuration method.

Note that the PivotGrid does not use the dataCellTemplate, columnHeaderTemplate, and rowHeaderTemplate configurations during Excel export and exports only its data, because the templates may contain arbitrary HTML which cannot be converted to Excel column values.

Additional Apps

This PivotGrid example is part of a unique collection of hundreds of ASP.NET MVC demos, with which you can see all Telerik ASP.NET MVC components and their features in action. View the source code of the demos from the library or directly adapt, and edit them and their theme appearance in the ThemeBuilder.

Support & Learning Resources

Additional Resources