Click here to Skip to main content
14,692,401 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
Hi,

I developed a report with kendo grid in asp.net mvc. As per user requirement, I added kendo export to excel option. while clicking export excel data transferred to excel. I have a date column in my grid. It displays fine in report. But while transferring, date column format was changed as number.
Thanks in advance. Please any one can help me as early as possible.

What I have tried:

I searched in telerik sites and googled but i didn't get proper solution for my asp.net mvc kendo grid export excel
Posted
Updated 3-Jan-17 2:51am
v2
Comments
Karthik_Mahalingam 19-Oct-16 12:45pm
   
check this
http://www.telerik.com/forums/export-to-excel---format-date-to-have-am-pm
Pavan Kalyan 20-Oct-16 4:13am
   
I tried this link already and not worked for this kendo grid. asp.net mvc.
Pavan Kalyan 21-Oct-16 6:18am
   
Is there any solution for my issue.
Karthik_Mahalingam 21-Oct-16 7:47am
   
try formating to a string and download
Pavan Kalyan 24-Oct-16 8:11am
   
okay. i will try
Pavan Kalyan 24-Oct-16 11:48am
   
Yes. its working. i converted datetime to string variable. Its Now exporting datetime proerly in excel. thanks for your advice

1 solution

Hello,

I will go straight to the questions:
1. You could use an approach [similar to the following one ]in the event in order to set custom background color to the Grid cells.
2. You could find all the possible configuration options for the Workbook at the [following documentation page]. For example:

[sheets.rows.cells.bold]
[sheets.rows.cells.format]


Regards,
Nick
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900