[Solved] Export CVS - client side Group By

[Jigar]

Hi,

I want to export my data as per the group in grid. I am able to export data as per sorting, filter and page wise (demo) but I don't get a clue on how can I replace that href with groupBy data.

Can any one help please?

Thanks,

Jigar.

[Atanas Korchev]

Hello Jigar,

As far as I know the CSV format does not support groups.

All the best,
Atanas Korchev
the Telerik team

[Jigar]

Hi Atanas,

Thanks for your response. Right you have a valid point.

Thanks,

Jigar.

[judowalker]

Hi Atanas,

I'm using the article you wrote (http://www.telerik.com/support/kb/aspnet-mvc/grid/export-to-excel.aspx) to export my grid data to excel. I would like to export the groupings as well.

I noticed the ToGridModel method (example below) takes a groupBy parameter but your example passes in string.empty. Is there a way to pass it the groupBy query string and have it return an IGrouping. Or is there a way to cast the GridModel.Data IEnumerable into an IGrouping?

GridModel model = Model().ToGridModel(page, 10, orderBy, string.empty, filter);

This will allow me to loop through each group in the grouping in order to create the rows in the spreadsheet.

Thanks,
Tudor