Hi. I would like to group data in excel which containes a few duplicated small tables in excel using C#. Here's the code i used:

Code:
objSheet.get_Range("A" + m_EndOfRow.ToString(), Type.Missing).get_Offset(1, 0).EntireRow.Group(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
but it only chooses to group the first row. I need this to be done for 5 other tables as well. Please help and advise. Thanks in advance.

Regards.