This excel automation is possible in UiPath

[ARahman (Md. Abdur Rahman)]

This excel automation is possible…? From below excel screen

The source file is…

[jcvsalinas (Julius Cris Salinas)]

Yes you can use filter data table and keep the rows containing SRV-CALL

Then Sort according to “Resouce Name”

[ARahman (Md. Abdur Rahman)]

Thanks @jcvsalinas, I’m trying it

[samir (Samir Mohite)]

Hi @ARahman,

To achieve the same, I’ll suggest you to follow the steps below.

1. Use Read Range activity to read excel sheet and create output var for that —> DT

2. To divide data with respect to Resource & Resource Name, you need to get distinct Resources by using following code in Assign activity,
   DistinctResource = DT.DefaultView.ToTable(True,"Resource","Resource Name")
   here,
   DistinctResource —> DataTable var, will hold all distinct Resources.

3. Use For Each Row activity to iterate through DistinctResource.

4. Take Filter Data Table activity inside for each row, to filter DT using each Resource. (As given below)
   

   
   
   here,
   row(0).ToString —> will hold Resource value for each iteration.
   row(1).ToString —> will hold Resource Name value for each iteration.
   FilteredDT —> filtered datatable using that Resource.
   Now, you’ve Resource, Resource Name & filtered data with respect to that Resource at every iteration. So using writline for Resource/Resouce Name & Write Range for filtered table. (With calculating Index logic)

for Total value, i don’t see anything related from those visible columns, so if there’s a column related to that then, you can use the logic to get the value. So, you can simply use correct Index logic in range for writeline & write range at the end of the for each row.

That’s it.