Excel Export with group by date only

[Kyle Smith]

I followed the group by date only example in the knowledge base. Works great.

https://docs.telerik.com/kendo-ui/knowledge-base/grid-group-by-date-only

 

The only issue I have is that when I export to excel, i get only the date portion of the value even though the grid displays the date and time via the template. How can I get around this so Excel export also uses the template value?

[Kyle Smith]

FYI,

I got around this by adding a new column to have the "No Time" value and set it to be hidden. That way the grouping works based on that column and the actual column value shows with the time value and exports to excel with the time value.

[Viktor Tachev]

Hi Kyle,

Thank you for sharing the approach you went for with the community.

The implementation you are using is suitable for this scenario. Out of the box templates are not exported to Excel - only the data. The reason for this is that a template can include arbitrary HTML that cannot be converted to valid values in Excel. For more information on the excel export feature check out the article below:

https://docs.telerik.com/kendo-ui/controls/data-management/grid/export/excel-export

 

Regards,
Viktor Tachev
Progress Telerik