how to export datatable to excel with row grouping.

how to export datatable to excel with row grouping.

NilamkunvarNilamkunvar 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

  • colincolin Posts: 15,177Questions: 1Answers: 2,590

    This thread should help, it's asking the same thing.

    Cheers,

    Colin

  • allanallan Posts: 61,972Questions: 1Answers: 10,160 Site admin

    Just to add - there is no built in support for export with row grouping.

    Allan

  • kthorngrenkthorngren Posts: 20,425Questions: 26Answers: 4,794

    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

Sign In or Register to comment.