How to check queue transection AC no is equal in Excel

I’m using reframwork and queue.
In input excel i have like this table

I want to fetch amount in perticular Acno that date.

I want write output value in amount column with check with transection/processed item Acno and in Excel Acno column after that write in amount column and then status as success.

If rerun the process it will check success item in status and add remaining in queue and proceed with remaining Acno.


For checking transaction data on excel and update you can use find/Replace activity to find the ac/no in the excel which gives you the row index. This can be used to get the date and other details by using read cell activity and the row number fetched.

Then those details can be validated using if condition

Can you be a little more clear on what is needed, if this is not the requirement