This is a migrated thread and some comments may be shown as answers.

Excel Export Template Columns

1 Answer 270 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Joe
Top achievements
Rank 1
Joe asked on 21 Jul 2016, 09:17 PM

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.

 

1 Answer, 1 is accepted

Sort by
0
Kostadin
Telerik team
answered on 26 Jul 2016, 12:30 PM
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.
Tags
Grid
Asked by
Joe
Top achievements
Rank 1
Answers by
Kostadin
Telerik team
Share this question
or