Updating Excel in Process state Reframework

Help Activities
,
1

Hi Friends,

I’m using REFramework in my project there I have a Datatable consists of more columns but adding queue based on the column-“Match”, In Match column it has Matching and Not Matching only two values, here I’m filtering only Match columns and adding it to the Queue, also I’m adding one unique value into the queue, Once process done I need to update same excel in the status column which has Matching value in Match Column, if item retried I have to overwrite the same row, should not append the same row, Anyone pls Suggest.

2

@Manii_K

use look up and get the row number and use it to update the status

looks up can be done using any unique column you have

cheers

3

Hi @Anil_G

Thanks for the reply, Could you pls elaborate.

4

@Manii_K

use the above and searhc for the row you need to update

use the output of it in the next activity write cell to write to corresponding rows…columns are something you already know

cheers

5

Hi, here’s a suggested flow:

Use Filter Data Table to filter rows where the “Match” column has a value of “Matching”. These rows will be added to the queue.

For each item added to the queue, ensure you’re adding a unique value (like an ID) to later identify and update the same row in Excel.

After processing, update the “Status” column in Excel based on the unique value, ensuring you overwrite the existing row instead of appending a new one.

If the item is retried, make sure you update the same row, not adding a duplicate. Match the unique identifier to find the correct row in the Excel file.
Best regards,
Ania