Excel with flag updates

[Sonal12 (Sonal)]

Hi,
I am new to Ui Path. I need help with below scenario, any help is appreciated.
I have column A(ID) and Column B(Status) in excel with multiple rows. My process file have to read the top row with status “Y” and pick the ID associated with it and “Type into” the web application and once done the picked row status have to be changed to “N”. How do I loop through reading “Y” until all ID’s with status “Y” are updated to “N”. Thanks in advance

[Yoichi]

Hi,

Hope the following helps you.

It might be better use WriteCell activity instead of Assign activty if you’re concerned about exception during input to application.

Regards,

[Sonal12 (Sonal)]

Thanks for the quick response. This worked