Excel Export lacks data kendo grid column group

1 Answer 98 Views
Excel Export Grid
Caesar
Top achievements
Rank 1
Caesar asked on 22 Dec 2022, 09:51 AM | edited on 22 Dec 2022, 10:20 AM

Hi,

I am facing a case like this:
Source: https://stackblitz.com/edit/angular-v6xzlw-vrqmxj
I am using kendo grid.
The data displayed on the grid is ok but when exporting excel, the data is missing.
I've been trying to find a way for a few days but still can't solve it.
Please support.

Thanks!

May be an image of text that says '区 Export Excel Name Name Number AB 001255* AV= 66000000 Base Revenue 100001 Name Ratio 100002 196507. 90740000005 008001 AV= 10000000 Base Revenue 100003 0.27390444 Ratio Name 180776 93040000004 100004 Base Revenue 191478.3618 Name 6 0. 15730977 100005 0.29011873 7414.54119999999 15730. 977 Name7 100006 191478.3618 0.17790082 Name8 100007 117414.54119999999 31639.231799999998 Name 100008 0.04793823 122.7336 Name 10 100009 0.00018596 245.4672 Name 11 1639.231799999998 122.7336 100010 0.00037 92 Name 12 100011 245.4672 135728.67 Total 100012 0 0.2056495 0 135728.67 2593.6086 0.00392971 2593.6086'

1 Answer, 1 is accepted

Sort by
0
Martin Bechev
Telerik team
answered on 23 Dec 2022, 08:38 AM

Hi Caesar,

Thank you for the provided example.

This is one of the limitations of the Excel export functionality - during the export to Excel, the cell and detail column templates of the Grid are not evaluated:

Regards,


Martin
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Caesar
Top achievements
Rank 1
commented on 23 Dec 2022, 12:38 PM

Tags
Excel Export Grid
Asked by
Caesar
Top achievements
Rank 1
Answers by
Martin Bechev
Telerik team
Share this question
or