New to Telerik UI for ASP.NET Core? Download free 30-day trial
ASP.NET Core PivotGrid Excel Export
- EXAMPLE
- VIEW SOURCE
-
Change Theme
defaultDefault Theme
- Main
- Main Dark
- Nordic
- Ocean Blue
- Ocean Blue A11Y
- 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
Also available for:
CLIENT-SIDE API SERVER-SIDE APIDescription
The Telerik UI for ASP.NET Core 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.