[Solved] Export to Excel datatype

[Marco]

Hello,
In the Radgrid i have a string field that must stay a string. Like '0011'.
When i export to excel this becomes a numeric value 11.

I hope someone can show me a way how to export the datatype also to Excel.
I have search the documentation but didn't found it.

thanks

[Vlad]

Hi Marco,

You can use ExcelML export to achieve this. Please check this example:
http://www.telerik.com/DEMOS/ASPNET/Prometheus/Grid/Examples/GeneralFeatures/Exporting/DefaultCS.aspx

All the best,
Vlad
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Marco]

Hello Vlad,

I came across that demo, but this gives in my application a error, showing that the css file is missing..
The css file is located in the standard App_Themes folder, and is functioning normaly in the whole application.

I spend alot of time to solve that error but didn't found a solution for that yet.
I use a css in the radgrid, but even if i remove the css class from the radgrid structure, i getting this error.
Thats why i went back, to the standard Excel export.

Besides the above, i have another problem i try to solve according to the export. Inside the the CSV export, i dont/t want to use quotes, but there a standard quotes arounding the data. Hopefully you have a solution for this also.

Thanks

[Rosen]

Hi Marco,

Unfortunately I was unable to reproduce the error concerning the Export to ExcelML on my local machine. Can you please send us (attached to a formal ticket) a small working project where this unwanted behavior can be observed?

To you other request:
I'm afraid this is not supported. Please excuse us for any inconvenience.
 
Best regards,
Rosen
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Marco]

Hello Rosen,

I will try to send a support ticket, with the css error this week.

For the csv quotes there is a workaround.
If i first do a Excel export, and then save the data as csv, the quotes are gone.
This will do fine for me for the moment, so thats not a big prob.

Thanks,

Marco