Export Pivot Grid with Templates

Thread is closed for posting
1 posts, 0 answers
  1. Eyup
    Eyup avatar
    11 posts
    Member since:
    Oct 2012

    Posted 07 Jan 2019 Link to this post


    Telerik Product and Version


    Supported Browsers and Platforms

    All browsers supported by Telerik UI for ASP .NET AJAX

    Programming language



    Pivot Grid with templates in view (browser) mode:
    Pivot Templates 1

    Pivot Grid content when exported to Excel:
    Pivot Templates 2

    This sample demonstrates how you can export RadPivotGrid to Excel with templates. By default, the pivot grid does not take into account the content of the templates when exporting. By implementing these points, however, this can be possible:

    1. Bind the template controls programmatically using their DataBinding event handler.
    2. Use the PivotGridCellExporting event to access the controls just before exporting and set the value manually to the cell. 
    3. Exporting to XLSX requires the Telerik document processing libraries as described in the XLSX and DOCX formats article.

Back to Top

This Code Library is part of the product documentation and subject to the respective product license agreement.