Export Pivot Grid with Templates

1 posts, 0 answers
  1. Eyup
    Eyup avatar
    11 posts
    Member since:
    Oct 2012

    Posted 07 Jan Link to this post

    Requirements


    Telerik Product and Version

    3.5+

    Supported Browsers and Platforms

    All browsers supported by Telerik UI for ASP .NET AJAX

    Programming language

    C#

    PROJECT DESCRIPTION


    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