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

Date format in export to excel file

1 Answer 149 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Yanesh
Top achievements
Rank 1
Yanesh asked on 08 Sep 2017, 10:09 AM

Hi,

In Kendo Grid - Export to Excel, is there any way to set the format of an excel column. I need to set the date format to "dd-MMM-yyyy" for transaction date column instead of using default format.


I am using server side grid

1 Answer, 1 is accepted

Sort by
0
Stefan
Telerik team
answered on 12 Sep 2017, 12:10 PM
Hello Yanesh,

The desired result can be achieved by setting specific format options for the exported cell during the excelExport event:

https://dojo.telerik.com/aKAXa

https://admin.telerik.com/docs.telerik.com/kendo-ui/api/javascript/ui/grid#events-excelExport

I hope this is helpful.

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.
Tags
Grid
Asked by
Yanesh
Top achievements
Rank 1
Answers by
Stefan
Telerik team
Share this question
or