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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


Thread ID:





72553 Mar 26,2008 11:15 AM UTC Mar 27,2008 06:24 AM UTC WinForms 1
Tags: XlsIO
Asked On March 26, 2008 11:15 AM UTC


I'm creating an Excel Sheet that contains personal data like adress private, address business, phone, etc.

Now I want to group by collumns. Therefore I'm using the following code:

sheet.Range[1, 3, 1, 5].Group(ExcelGroupBy.ByColumns);
sheet.Range[1, 6, 1, 8].Group(ExcelGroupBy.ByColumns);
sheet.Range[1, 9, 1, 15].Group(ExcelGroupBy.ByColumns);

I want to have three groupings. But what I get is one single grouping for column 3 to 15.

Can you help me how to add more then one grouping (not cascaded).


Administrator [Syncfusion]
Replied On March 27, 2008 06:24 AM UTC

Hi Christoph,

Thanks for considering Syncfusion.

This is normal behavior of MS Excel also. If you set the first Group range to [1, 3, 1, 4] and second group range to [1, 5, 1, 8], the result will be single grouped range. Please refer the below modified code to get three grouped range in single row.

//Group by row
sheet.Range[1, 3, 1, 4].Group(ExcelGroupBy.ByColumns );
sheet.Range[1, 6, 1, 8].Group(ExcelGroupBy.ByColumns);
sheet.Range[1, 10, 1, 15].Group( ExcelGroupBy.ByColumns);

Here is the video clip for MS Excel normal behavior


Please let me know if you need any further assistance.

Best Regards,


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