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

Radgrid Exporting ExcelML with Carriage Return

2 Answers 29 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Mark
Top achievements
Rank 1
Mark asked on 06 Aug 2014, 04:58 PM
Peeps,

Please save the hair I have left.  I want to export some data from a radgrid, but the radgrid has </br> in the data.  Im doing a find and replace in the RadGrid1_ExcelMLExportRowCreated function, replacing </br> with &#13;&#10;.  However the string is being encoded into HTML therefore it ends up looking like this in the xml &amp;#13;&amp;#10;.  How do I escape & so it gets injected as an ampersand, or is there anyway i can override an element that replaces all </br> to carriage return.  Surely someone has done this.

2 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 1
answered on 07 Aug 2014, 05:50 AM
Hi Mark,

I guess you want to replace the </br> tag in Excel. Please take a look at the following forum to achieve this:
http://www.telerik.com/forums/radgrid-excel-export-lt-br-gt-to-new-line#VwafLsLn5kiZEQGK8ekjTw

Thanks,
Princy
0
Daniel
Telerik team
answered on 11 Aug 2014, 07:23 AM
Hello Mark,

The line ending character in ExcelML is "&#10;". The easiest way to insert/replace it would be to use the GridExporting event as suggested in that forum post.

Regards,
Daniel
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
Tags
Grid
Asked by
Mark
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 1
Daniel
Telerik team
Share this question
or