Grouping data in Excel using C#

[rshin2020]

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:

Please Login or Register  to view this content.

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.

[Benjaminhaynes]

As an example, let’s take an employee moving from one department to another.

Please Login or Register  to view this content.

I think you are satisfied with this example dapfor. com