Export to Excel

5 posts, 0 answers
  1. Jan
    Jan avatar
    58 posts
    Member since:
    May 2010

    Posted 22 Feb 2011 Link to this post

    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. 
  2. Yordanka
    Admin
    Yordanka avatar
    634 posts

    Posted 22 Feb 2011 Link to this post

    Hi DCMS,

    Could you specify the html tag which causes error ?
     
    Kind regards,
    Yordanka
    the Telerik team
    Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
  3. DevCraft banner
  4. Jan
    Jan avatar
    58 posts
    Member since:
    May 2010

    Posted 22 Feb 2011 Link to this post

    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
  5. Pavel Pavlov
    Admin
    Pavel Pavlov avatar
    2039 posts

    Posted 23 Feb 2011 Link to this post

    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
    Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
  6. Jan
    Jan avatar
    58 posts
    Member since:
    May 2010

    Posted 01 Mar 2011 Link to this post

    Hello Telerik,

    Problem is solved.
    Thank you.
Back to Top
DevCraft banner