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.
Unfortunately, activation email could not send to your email. Please try again.

How to read Group information?

Thread ID:

Created:

Updated:

Platform:

Replies:

18640 Sep 5,2004 06:28 PM Sep 9,2004 02:04 AM Windows Forms 3
loading
Tags: XlsIO
Greg
Asked On September 5, 2004 06:28 PM

Good Day, I have sucessfully set Group outlining, but do not know how to read the grouping information from an xls file. Please help. Thanks, Greg

Administrator [Syncfusion]
Replied On September 7, 2004 07:35 AM

Hi Greg, Currently it is not possible to read group information. We will be adding new properties to read groups. The implementation will be something similar to this 1) bool IsGrouped { get; } //Check if cell is grouped. 2) IRange GroupArea { get; } // Retrieve the Group range to which the specified range belongs to. 3) ExcelGroupBy GroupType { get;} // Retrieve is the group is a vertical or horizontal group. Please let me know if you have any questions. Best regards, Stephen. >Good Day, > >I have sucessfully set Group outlining, but do not know how to read the grouping information from an xls file. > >Please help. > >Thanks, >Greg >

Greg
Replied On September 7, 2004 10:20 AM

Stephen, Of course, a cell may be in more than one group range (a3 is in A1:A5 row group and A3:A4 row group). So returning a single group for a cell may be insufficient. For my use, I would like to have a collection of groups much like the named range collection. Perhaps: worksheet.GroupsByRow Range1 Range2 ... .GroupsByColumn each having a .Count, etc. Then I can iterate through the groups to set them up properly in my system. Also having your proposal would be good, if I can get a collection back. i.e. IRange.Groups returns collection of Groups having overall Group IRange and row/col type that this IRange belongs to. Hope my thoughts help. Thanks, Greg >Hi Greg, > >Currently it is not possible to read group information. We will be adding new properties to read groups. The implementation will be something similar to this > >1) bool IsGrouped { get; } //Check if cell is grouped. > >2) IRange GroupArea { get; } // Retrieve the Group range to which the specified range belongs to. > >3) ExcelGroupBy GroupType { get;} // Retrieve is the group is a vertical or horizontal group. > >Please let me know if you have any questions. > >Best regards, > >Stephen. > > > >>Good Day, >> >>I have sucessfully set Group outlining, but do not know how to read the grouping information from an xls file. >> >>Please help. >> >>Thanks, >>Greg >>

Administrator [Syncfusion]
Replied On September 9, 2004 02:04 AM

Hi Greg, Thanks for your suggestions. I have passed them on to the development team. I will keep you informed on the status of this feature. Thanks. Best regards, Stephen. >Stephen, > >Of course, a cell may be in more than one group range (a3 is in A1:A5 row group and A3:A4 row group). So returning a single group for a cell may be insufficient. For my use, I would like to have a collection of groups much like the named range collection. > >Perhaps: > >worksheet.GroupsByRow > Range1 > Range2 > ... >.GroupsByColumn > >each having a .Count, etc. > >Then I can iterate through the groups to set them up properly in my system. > >Also having your proposal would be good, if I can get a collection back. i.e. IRange.Groups returns collection of Groups having overall Group IRange and row/col type that this IRange belongs to. > >Hope my thoughts help. > >Thanks, >Greg > > >>Hi Greg, >> >>Currently it is not possible to read group information. We will be adding new properties to read groups. The implementation will be something similar to this >> >>1) bool IsGrouped { get; } //Check if cell is grouped. >> >>2) IRange GroupArea { get; } // Retrieve the Group range to which the specified range belongs to. >> >>3) ExcelGroupBy GroupType { get;} // Retrieve is the group is a vertical or horizontal group. >> >>Please let me know if you have any questions. >> >>Best regards, >> >>Stephen. >> >> >> >>>Good Day, >>> >>>I have sucessfully set Group outlining, but do not know how to read the grouping information from an xls file. >>> >>>Please help. >>> >>>Thanks, >>>Greg >>>

CONFIRMATION

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.

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.

;