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 : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to read Group information?

Thread ID:

Created:

Updated:

Platform:

Replies:

18640 Sep 5,2004 10:28 PM UTC Sep 9,2004 06:04 AM UTC WinForms 3
loading
Tags: XlsIO
Greg
Asked On September 5, 2004 10:28 PM UTC

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 11:35 AM UTC

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 02:20 PM UTC

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 06:04 AM UTC

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.

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

;