Export grid to excel with different cell formats

0 Answers 88 Views
Grid
Becky
Top achievements
Rank 1
Becky asked on 22 Mar 2023, 12:30 PM

Hi,

I have used the tutorial https://demos.telerik.com/aspnet-mvc/grid/server-export in order to do a server export of a grid to excel. My grid has columns that contain text values, numerical values and date values.

I have set the formats accordingly on the .cshtml page, but it seems as though the exporter ignores this and it needs me to set the 'NumberFormat' to 'dd/mm/yyyy' in the SpreadCellFormat in order to show the date correctly. However that then applies the same format to every cell in the spreadsheet, meaning that the numerical columns turn to dates.

Has anyone else found this and have a solution?

Thanks

Becky

Anton Mironov
Telerik team
commented on 27 Mar 2023, 11:00 AM

Hi Becky,

Thank you for the details provided.

I will speak with the Document Processing Library Team and I or their member will come back to you.

 

Kind Regards,
Anton Mironov

No answers yet. Maybe you can help?

Tags
Grid
Asked by
Becky
Top achievements
Rank 1
Share this question
or