I have a Nested radgrid (master & DetailTable) ...when using export to excel i want to display the detailTable cell values using offset 0,2 .
that means i want to shif the cell position by 2 and merge the detail table headers with the master
i'm using
ExcelMLExportRowCreated & ExcelMLExportRowCreated
C#2.0, Telerik Rad Ajax Q3,2010
Exmaple:-
this is what i have
OrdID Date Amount
ord#1 Mar3 $80
ITEM# NAME Amount
Item#1 ItemName1 $50
Item#2 ItemName2 $30
ord#2 Mar3 $100
ITEM# NAME Amount
Item#1 ItemName1 $45
Item#2 ItemName2 $55
should be change to....
OrdID Date ITEM# NAME TotalAmount
ord#1 Mar3 $80
Item#1 ItemName1 $50
Item#2 ItemName2 $30
ord#2 Mar3 $100
Item#1 ItemName1 $45
Item#2 ItemName2 $55