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

Formating column as number when exporting grid that was initialized by table

1 Answer 38 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Matt
Top achievements
Rank 1
Matt asked on 23 Jul 2015, 09:14 PM

We have a grid that was initialized by table and now when we try to export it to excel the numeric columns are showing up as text in the generated excel spreadsheet.

 

Is there a way to convert these to numbers and format them appropriately when exporting to excel?

1 Answer, 1 is accepted

Sort by
0
Kostadin
Telerik team
answered on 27 Jul 2015, 12:00 PM
Hello Matt,

A possible solution is to apply a custom format to the cells which contain a numeric values. Please check out the following sample which demonstrates how to achieve that.

Regards,
Kostadin
Telerik
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
Tags
Grid
Asked by
Matt
Top achievements
Rank 1
Answers by
Kostadin
Telerik team
Share this question
or