Excel Export Template Columns

2 posts, 0 answers
  1. Joe
    Joe avatar
    7 posts
    Member since:
    Nov 2013

    Posted 21 Jul 2016 Link to this post

    We are trying to update our Excel exports by changing the Export Format to XLSX, due to the current issue with exporting RadGrid to HTML - http://www.telerik.com/forums/html-based-export-format-is-not-working-in-excel-2010

    However, I am unable to export RadGrid Template Columns containing RadNumericTextBox fields.   The Excel cells return blank.  How can I get the export to show the values on screen.

    I have tried to set the GridItem Text value during ItemDataBound as shown in this example:  http://www.telerik.com/forums/export-excel-gridtemplatecolumn-radcombobox#-N46Be62GESFQDNwu0-vbA

    but it does not affect the Export.    

     

    Any help is appreciated, 

    Thanks.

     

  2. Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 26 Jul 2016 Link to this post

    Hi Joe,

    A possible solution is to add a Label control to the template that will have the same value as the RadNumericTextBox control and will be hidden. When you export the grid you will show the Label control which text will be exported. Please check out the attached sample which demonstrates that.

    Regards,
    Kostadin
    Telerik by Progress
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Back to Top