Export to Excel also exports the group footer template

[Sanjay Salunkhe]

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.

[Kiril Nikolov]

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

 

 

[Michelle]

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.

[Kiril Nikolov]

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

 

 

[NTH]

Any news on this?

[Stefan]

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