Hello,
When I'm trying to export my grid content to Excel with format settings to ExcelML only a blank Excel worksheet is opened. When changing the format to HTML instead of ExcelML the export does work as expected for HTML.
My grid is based on a custom datatable that is assign on the OnNeedDataSource.
Does anyone have a solutions for this problem??
Regards,
Jos Meerkerk
When I'm trying to export my grid content to Excel with format settings to ExcelML only a blank Excel worksheet is opened. When changing the format to HTML instead of ExcelML the export does work as expected for HTML.
My grid is based on a custom datatable that is assign on the OnNeedDataSource.
Does anyone have a solutions for this problem??
Regards,
Jos Meerkerk
5 Answers, 1 is accepted
0

Princy
Top achievements
Rank 2
answered on 30 Jan 2012, 10:43 AM
0

RvdGrint
Top achievements
Rank 1
answered on 30 Jan 2012, 03:30 PM
Princy,
thnx but when I check the cellcollection of the row on the ExcelMLExportRowCreated event this is empty.
Any idea??
Regards,
Jos
thnx but when I check the cellcollection of the row on the ExcelMLExportRowCreated event this is empty.
Any idea??
Regards,
Jos
0

RvdGrint
Top achievements
Rank 1
answered on 30 Jan 2012, 04:03 PM
http://www.telerik.com/community/forums/aspnet-ajax/grid/export-to-excelml-is-blank.aspx
According to this thread it si snot possible to export Template columns to ExcelML and that is just what I'm trying to do.
Regards,
Jos
0
Hello,
Have you tried the approach from the project my colleague has attached in the thread?
Please follow it and let me know how it goes.
All the best,
Mira
the Telerik team
Have you tried the approach from the project my colleague has attached in the thread?
Please follow it and let me know how it goes.
All the best,
Mira
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now
0

RvdGrint
Top achievements
Rank 1
answered on 01 Feb 2012, 08:57 PM
Mira,
I did not use the approach of you're collegue.
I've added the DataField property to the GridTemplateColumn and it worked fine for me at this moment.
Regards,
Jos
I did not use the approach of you're collegue.
I've added the DataField property to the GridTemplateColumn and it worked fine for me at this moment.
Regards,
Jos