Appending Monthly data from single sheet to different excel sheets

Help Studio
, ,
1

I am trying to achieve below the requirement.

I am getting a consolidated report every month for multiple clients (With Client names) in a single excel sheet as shown below.

Report
Report763×126 4.2 KB

Now I want to read each “client name” from the above report and pick the excel which is matching the client name and append the respective client data to the respective client sheet (Will have each sheet for each client) month on month basis as shown below.
Report2

Help will be much appreciated!

2

https://www.google.com/search?q=uipath+grouping+data+site:forum.uipath.com&safe=active&rlz=1C1GCEA_enUS956US956&sa=X&ved=2ahUKEwikzo_nrrz2AhXymeAKHUSUDzsQrQIoBHoECA8QBQ&biw=1920&bih=937&dpr=1

3

How I would do this.

Create a variable destinationDTs as dictionary(of string, datatable).Read Range the sheet into a datatable. For Each through the datatable and for each row, Add Data Row to destinationDTs(row.Item(“Client Name”)).

At the end you have a dictionary that contains one datatable for each Client Name. Then you can just loop through the dictionary keys and write each datatable to a separate Excel file.