Can anyone tell me how can i extract the data which is highlighted in red, also the debit amount


Welcome to UiPath forum

  1. Use a excel application scope and pass the filepath of excel as input and use read range and get the output as datatable named dt

  2. Now use a FOR EACH ROW activity and pass dt as input

  3. Inside the loop use a assign activity to get the string value you want and the debit column value with another assign activity like this

I could see a common string along with your value
Replace them with null value so that you get your exact value

str_output_1 = row(2).ToString.Replace(“your common text”, “”)

For debit use another assign inside the for each row loop

str_output_2 = row(“Debit”).ToString

Cheers @Lakshya_Sharma