how to export datatable to excel with row grouping.
how to export datatable to excel with row grouping.
Nilamkunvar
Posts: 1Questions: 1Answers: 0
i am not able to export datatable data to excel with row grouping.currently the grouping information will be ignored on export.
Answers
This thread should help, it's asking the same thing.
Cheers,
Colin
Just to add - there is no built in support for export with row grouping.
Allan
I created some code to do this. See this example from this thread. It supports exporting the groups in one sheet or multiple sheets; one for each group.
Kevin