How to read cell from csv

I have an CSV generated by an application and would like to retrieve the data start from E5 → output to variable → save to excel file. Create a loop do the same process to E6 till empty cell.
Please help me how to get data start from E5?

@AL13 - try the Read Range activity and set range = E5.
To keep it dynamic, you can do range = “E”+counter and then increment the counter by 1.

OR, read the complete excel into a datatable, drop Columns A to D and then write datatable to excel.


You can try using For each row look, create the Index variable, put a IF condition, check below for your reference

Hope this helps


@sumitd - Read Range does not support CSV and only can open xls or xlsx.