This is a migrated thread and some comments may be shown as answers.

Export to Excel also exports the group footer template

5 Answers 1014 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Sanjay Salunkhe
Top achievements
Rank 1
Sanjay Salunkhe asked on 13 Apr 2015, 11:58 AM

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.

5 Answers, 1 is accepted

Sort by
0
Kiril Nikolov
Telerik team
answered on 15 Apr 2015, 08:46 AM

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!
 
0
Michelle
Top achievements
Rank 1
answered on 19 Jun 2015, 05:59 PM
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.
0
Kiril Nikolov
Telerik team
answered on 23 Jun 2015, 07:46 AM
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!
 
0
NTH
Top achievements
Rank 1
answered on 30 Jun 2017, 11:20 AM
Any news on this?
0
Stefan
Telerik team
answered on 04 Jul 2017, 08:20 AM
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 (charts) and form elements.
Tags
Grid
Asked by
Sanjay Salunkhe
Top achievements
Rank 1
Answers by
Kiril Nikolov
Telerik team
Michelle
Top achievements
Rank 1
NTH
Top achievements
Rank 1
Stefan
Telerik team
Share this question
or