Export to Excel

[Jan]

Hello Telerik,
We have problem opening excel file.
We exported list of customers to excel. If customer name contains html tag in there name error occurred. 

[Yordanka]

Hi DCMS,

Could you specify the html tag which causes error ?
 
Kind regards,
Yordanka
the Telerik team

[Jan]

Hello Yordanka,
Thank you for your answer.

If we name customer "Beer factory 1 <amsterdam>", and export data with this value error occurred.

Best Regards,
DCMS

[Pavel Pavlov]

Hello DCMS,

I have checked the issue . Here are my findings :

RadGridView when exporting does not process the content additionally . It keeps it in its original state.
So when using special symbols in data, indeed the may conflict with HTML encoding.

Now the solution :

You will need to handle the Exporting event of RadGridView.
Inside of the event handler you will need to take care of escaping the HTML problematic characters ( e.g. replacing  "<" with &lt;   e.t.c.


Best wishes,
Pavel Pavlov
the Telerik team

[Jan]

Hello Telerik,

Problem is solved.
Thank you.