Export Grouping to Excel ML

[Sharon Eden]

Hi,

I need to find a way to export a gridview to excel but without duplicate data in some of the columns. for example if i have three columns, customer ID, date  and revenue, i'd like to have the customer ID (which is the same for several consecutive rows) displayed only for the first row with the same ID while the other column should display all of their values.

as  far as i understand there are two option:
1. export to Excel the gridview with its grouping hierarchy to excel using the ExcelML method. but i cant find a way to do it. is this possible at all?

2. another option it to clone the gridview (i need the original for the display) and clear the cells with the redundant ID's, but i couldn't find a way to clone the grid view.

thanks in advance for your help.

Sharon.

[Sharon Eden]

Any news about this one?

Thanks.

[Martin Vasilev]

Hi Sharon Eden,

Thank you for writing.

Currently, RadGridView does not support exporting grouped data to an Excel file. However, I think you can achieve described result by using ExportToExcelML class and its ExcelCellFormating event. This way you can remove the unwanted values only in the exported file. Please find more information about this event in our product documentation.

Let me know if you have any additional questions.

All the best,
Martin Vasilev
the Telerik team