How do I group Rows and Columns

1 min read

The IRange class has the Group and Ungroup methods that can be used for grouping and ungrouping rows and columns in a worksheet.

//Grouping Rows and Columns
mySheet.Range["A1:A5"].Group(ExcelGroupBy.ByRows);
mySheet.Range["A1:E1"].Group(ExcelGroupBy.ByColumns);

'Grouping Rows and Columns
mySheet.Range("A1:A5").Group(ExcelGroupBy.ByRows)
mySheet.Range("A1:E1").Group(ExcelGroupBy.ByColumns)

Here is the sample for your reference:

Did you find this information helpful?

Yes

Comments (0)