Excel Automation - Help Grouping Rows

[matt23lucier]

I am creating an application that gathers information from several databases and then creates an excel report with this information. The problem is that there are thousands of rows and I do not want them all to be visible at first. I know how to create the excel report through c# but I am not sure of to Group some rows together so that they are hidden unless the user expands these rows. Does anyone know how to do this?
Thanks
Matt

 

[AlexCuse]

I imagine there is a way to select and hide some rows, but I have never had to do it.

If you could identify the rows you need to hide, then it becomes simple:

     // VBA, should be easy conversion
    Rows("3:14").Select
    Selection.EntireRow.Hidden = True

HOpe this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[AlexCuse]

Hey, I just had to hide some columns for a report I was working on. I had to first select a range, then hide the entire column for selected range. I imagine it works the same for rows (but I don't want to mess with my report)

wRange = xlSheet.get_Range(xlSheet.Cells[1, mDT.Columns.Count + 1], xlSheet.Cells[1, 60]);
wRange.EntireColumn.Hidden = true;

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[matt23lucier]

Thanks for you help. I managed to figure it out for anyone who is interested. The following code will group the rows A4-A6 so they can be expanded anytime. Also this code will initially have the rows hidden.

Excel.Range rang = worksheet.Columns.get_Range("A4", "A6");
rang.Rows.Group(Type.Missing, Type.Missing , Type.Missing, Type.Missing);
rang.Rows.Hidden = true;

 

[matt23lucier]

AlexCuse I appreciate your help in this matter.
Matt