Hi,

I am trying to export a Grid into Excel file on which Grouping is applied on Some column(s).

But when I check that excel file, it shifts the first row under Grouped rows to one cells behind and thus my all values messes up.

e.g. In attched exported file, I have applied grouping on Name. So in Line number 10, there is an grouped entry with name "John". It looks fine untill not expanded but as soon as you expand it then first row under this grouping shifts to left by one cell and then in line number 12, it shown value 50 (value of Age) in the filed for Name (Under john) and so on.

I am using below method:-

 ExcelExporter.Export(grid.Value, workBook, 9, 0);

If I provide here "1" for starting column then it shifts all the values including summary to one cell in right.

Please let me know what function can I use here to achieve the proper export functionality.

Thanks,

Kuldeep Agrawal.