CODEWITHSUNDEEP
excelkendo-uinumber-formatting
saurbh
saurbh

Reputation: 511

Number formatted as text while exporting kendo grid to excel

I am using Kendo Grid which i need to export to excel as well. For displaying in the grid I am setting the format: '{0:n2}' to display the numbers in proper format. However, when I export this the columns are exported as Numbers formatted as text. While exporting I want to keep my columns as number only and not text so i could perform sum and avg in the excel. Any suggestions?

Upvotes: 2

Views: 3999

Answers (1)

Alag
Alag

Reputation: 1408

You need to use excelExport event and set format in that.

Check this dojo example to see ho to format cells as numbers.

Also check this link to see how to keep templates.

Upvotes: 1

Related Questions