How to update specific row status in excel

Help Studio
, , ,
1

Hello Everyone,

I have to update the excel of complition of each transaction

For example, i have 10 transaction in excel and 5 transaction are completed and bot suddenly stop or any other issues occurred so in that can whenever bot is going to start bot should take 6 tran bcz 5 is already done so now i have to update that 6 transaction after completing of that transaction so how i can do that.

Thanks

2

Hi @suraj_gaikwad

Add a new column in your Excel sheet, say “Status,” to keep track of the completion status of each transaction (e.g., “inprogress,” “Completed,” “Failed”).
If status column is blank or inprogress bot should start.

Thanks,
Muthuraj

3

Hi @Muthuraj_Chidhambaram1

Actually I’m not able to update final status bcz whenever i restart the bot it will start from 0 and my process transaction number id different.

IMG20240827205928
IMG202408272059281920×1440 489 KB

I u used write cell activity

Thanks

4

After finishing each transaction you need to update the status column with status. Each re you start to process a trasaction check the status column, if status is not completed start processing that row

5

Yes right but i can get that specific row the issue is i m not able to update that specific row

@Raj_esh

Thanks

6

When you are processing in for each loop , if u have a try catch to capture the error whenever bot fails , there try adding a add Data row to update the failed transaction status , in the catch block

7

@Raj_esh

I’m updating status in set transaction xmal.

Thanks

8

Are you trying to update your input file with a new column for status ? Is this in ReFramework ?

If in ReF you need to read the input file again and add the new column and update the status .

How I usually update the status for an end report is going into the set status flow and after the set status activity for each of the success, business and application exception add row activity . But I will have a data table only with id and status and reason, which I update in the set status flow

9

@suraj_gaikwad

I hope there is a column in your excel which is having unique value for each row …if yes then use look up or find/replace activity to find the row index first and then update the corresponding column

Cheers