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

Thread ID:	Created:	Updated:	Platform:	Replies:
145889	Jul 12,2019 06:08 AM UTC	Jul 16,2019 07:01 AM UTC	ASP.NET Core - EJ 2	1

Subscribe to this post

Tags: XlsIO

Hussain Nemati

Asked On July 12, 2019 06:08 AM UTC

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

Reply | Reply with quote

Abirami Varadharajan [Syncfusion]

Replied On July 16, 2019 07:01 AM UTC

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

Reply | Reply with quote

CONTACT US

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

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US