Hi ,
I tried to export data from radgrid to excel with command item and footer. I am able to export the data successfully. But I am not able to format the grid data . for example I am not able to set color for item and alternateitemtemplate.
wehen i am using xliml format then i am able to formate the color for item and alternateitemtemplate but I am not able to send command item and footer. xliml will work only if you set setonlydata = true.
I tried to export data from radgrid to excel with command item and footer. I am able to export the data successfully. But I am not able to format the grid data . for example I am not able to set color for item and alternateitemtemplate.
wehen i am using xliml format then i am able to formate the color for item and alternateitemtemplate but I am not able to send command item and footer. xliml will work only if you set setonlydata = true.
1 Answer, 1 is accepted
0
Hello Mritunjay,
When exporting to HTML Excel, you can easily distinguish whether the item is alternating or not:
If you want to export additional rows in ExcelML file, you should add them manually on ExcelMLExportRowCreated.
Let me know if you need more information.
Regards,
Daniel
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
When exporting to HTML Excel, you can easily distinguish whether the item is alternating or not:
protected void RadGrid1_ExcelExportCellFormatting(object source, ExcelExportCellFormattingEventArgs e){ if((e.Cell.Parent as GridItem).ItemType == GridItemType.Item) e.Cell.Style["background-color"] = "#BBB"; else if((e.Cell.Parent as GridItem).ItemType == GridItemType.AlternatingItem) e.Cell.Style["background-color"] = "#AAA";}If you want to export additional rows in ExcelML file, you should add them manually on ExcelMLExportRowCreated.
Let me know if you need more information.
Regards,
Daniel
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.