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

[Prithvi]

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

[Dimitrina]

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

[Prithvi]

 

Hi,

Error screen shots are attached, please look into that.

ExportFormat format = ExportFormat.ExcelML;

Prithvi

 

[Dimitrina]

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

[Prithvi]

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

[Dimitrina]

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