" />

Error in Export to Excel if the cell in grid has data like this: <DATA>

6 posts, 0 answers
  1. Prithvi
    Prithvi avatar
    19 posts
    Member since:
    Jul 2012

    Posted 05 Jul 2012 Link to this post

    Error in Export to Excel if the cell in grid has data like this:  <DATA>
  2. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 05 Jul 2012 Link to this post

    Hello,

     May I ask you what exoprt format do you use for the export? What is the error that you talk about?

    Kind regards,
    Didie
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  3. Prithvi
    Prithvi avatar
    19 posts
    Member since:
    Jul 2012

    Posted 05 Jul 2012 Link to this post

     

    Hi,

    Error screen shots are attached, please look into that.

    ExportFormat
    format = ExportFormat.ExcelML;

    Prithvi

     

  4. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 05 Jul 2012 Link to this post

    Hello,

     The error you got is because you are not allowed to export '<data>' as a value. You could subscribe for the ElementExporting event of the RadGridView and remove the tags '<' and '>' from the value to be exported.

    Please let me know how this works for you. 

    Greetings,
    Didie
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  5. Prithvi
    Prithvi avatar
    19 posts
    Member since:
    Jul 2012

    Posted 05 Jul 2012 Link to this post

    Hi,

    Prblm is solved!!!

    Can I give the default name for the excel sheet instead of default name "worksheet1" in the code behind?


    Thanks,
    Prithvi
  6. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 05 Jul 2012 Link to this post

    Hello,

    Unfortunately this is not supported. You could generate the Excel file yourself and export the data iterating through the Items collection of the GridView. 

    Greetings,
    Didie
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

Back to Top