We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:





145889 Jul 12,2019 06:08 AM UTC Jul 16,2019 07:01 AM UTC ASP.NET Core - EJ 2 1
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

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. 

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



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon