Export to Excel also exports the group footer template

6 posts, 0 answers
  1. Sanjay Salunkhe
    Sanjay Salunkhe avatar
    5 posts
    Member since:
    Jun 2009

    Posted 13 Apr 2015 Link to this post

    When i export a Kendo UI Grid to Excel (xlsx) file, it also exports the group footer template which in my case included hidden fields (<input type=hidden id="test"></input>)

    Is there a way we can suppress the export of the group footer template and the group header template.

    The header template also gets exported in the output xlsx file.

    In my case the group header template looks like the following:

    <script id="productCodeTemplate" type="text/x-kendo-tmpl">
        # var product = value; productArr = product.split(";"); #
        <span class="name" style="display: inline-block;width:500px;">Product Code: #: productArr[0]# </span>
    </script>

    The group footer template is as follows 

    groupFooterTemplate: "<input type='hidden' class='totalFooter' value='#=count#'></input><span class='totalFooterSpan'>Total</span>"

    Kindly see attached zip file for a sample of the exported excel.

  2. Kiril Nikolov
    Admin
    Kiril Nikolov avatar
    2596 posts

    Posted 15 Apr 2015 Link to this post

    Hello Sanjay,

    You can modify the exported document. Here is a documentation article that explains how to do it:

    http://docs.telerik.com/kendo-ui/web/grid/excel-export#customize-the-excel-document

    Regards,
    Kiril Nikolov
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  3. Michelle
    Michelle avatar
    46 posts
    Member since:
    Feb 2015

    Posted 19 Jun 2015 Link to this post

    I think it is a bug that the non-aggregate cells have plain data exported, but the aggregate cells get the entire group template exported.  It is inconsistent.  Export to PDF also works as expected by displaying the text, not HTML.
  4. Kiril Nikolov
    Admin
    Kiril Nikolov avatar
    2596 posts

    Posted 23 Jun 2015 Link to this post

    Hi Michelle,

    It is a feature that we currently do not supported. Please feel free to send a feature request, so we can consider it for future implementation. Thanks in advance.

    Regards,
    Kiril Nikolov
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  5. NTH
    NTH avatar
    2 posts
    Member since:
    Dec 2016

    Posted 30 Jun 2017 in reply to Kiril Nikolov Link to this post

    Any news on this?
  6. Stefan
    Admin
    Stefan avatar
    2913 posts

    Posted 04 Jul 2017 Link to this post

    Hello Valentina,

    Currently, the implementation is the same as discussed and changing it will result in breaking change in the widget. 

    The exported footer can be modified as demonstrated in the following example:

    http://docs.telerik.com/kendo-ui/controls/data-management/grid/how-to/excel/footer-alignment

    Also, I modified the example to demonstrate how to remove the footer rows:

    http://dojo.telerik.com/ILOsEQ

    Regards,
    Stefan
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top