Implementation of Group by (Field) by Importing DataTable in Excel

[Hussain Nemati]

Dear All,

I am currently using XlslO template marker, and it working fine, the only issue i have that i am unable to group by a field.

I have the following scenario I have DataTable contain (Student Name, Mobile, Email,Remark, Course) and i want to group Student by Course.

I am looking for possibility of automating "group by", therefore i will be able to generate future reports without rewriting the code.

I appreciate your support help me accomplishing the above scenario

[Abirami Varadharajan]

Hi Hussain, 

Thanks for your patience. 

You can group the desired range after applying template markers. We have prepared sample for your scenario of grouping particular field and the sample can be downloaded from the following link. 

Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Sample-1550093163.zip  

Please refer to below documentation to know more about Grouping rows and columns in detail. 

Documentation Link: https://help.syncfusion.com/file-formats/xlsio/worksheet-rows-and-columns-manipulation#group-or-ungroup-rows-and-columns  

Regards, 

Abirami