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,118Questions: 1Answers: 2,583

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

    Cheers,

    Colin

  • allanallan Posts: 61,453Questions: 1Answers: 10,055 Site admin

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

    Allan

  • kthorngrenkthorngren Posts: 20,150Questions: 26Answers: 4,736

    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.