Geeks With Blogs
Code.Blog Code Talk for the Game Developer

Lets say you have some code built to dynamically build an Excel report for your company.  You've got a header record with tons of detail records and want the ability to hide the detail records.  Add the following to select and group rows dynamically in ASP .NET (VB Code Shown):

xlWorkSheet.Rows.Range("B4", "B7").EntireRow.Group()

This will select rows from 4-7 (in this case in the B column) and group them together.  In this case, you would either have your details go from 4-6 and your Header at 7 or (since that seems backwards), a header at 3 and records from 4-6 (note: if 7 has data, that will be what is shown when the group is collapsed).

Posted on Thursday, June 5, 2008 9:47 AM Tutorials | Back to top

Comments on this post: Grouping in Dynamic Excel Sheet

# re: Grouping in Dynamic Excel Sheet
Requesting Gravatar...
I liked your site.
Left by Rob Miller on Apr 05, 2010 3:44 PM

Your comment:
 (will show your gravatar)

Copyright © Matthew Christian | Powered by: