Select data from Excel

I have an excel in that excel data is in two parts that are separated by an empty row and data is dynamic, I want data from starting to before the empty row. and after getting the data I want to remove some specific rows.

Hi @arun_kumar3,

Kindly go through it, this might can solve your problem.

Sanjit Pal


you can use the for each row activity and loop through the data, get the values until you reach the empty row, you should use an if condition inside the loop, then you can remove the row you want, let me see an excel file for reference so we can help you better


1 Like