use of Cell offset in Export to Excel, Nested RadGrid

[Robert]

Hi,

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