How to update data to excel when using Read Range workbook

[Latif (Robin)]

Im using Read Range Workbook to get Excel data as Datatable from flow name ReadExcel.

In other workflow i use first invoke Read excel flow to get the data and then I have used For each Row in Data Table to work with data.

Everything is going good I get the data but Now i forgot how to write back to dataTable.

Means I want to update a Column into the same CurrentRow if process is gone successfull or in Error.

But its not updating my Status column in datatable.
Hope some one can tell what im doing wrong.

[arjun.shiroya]

hi @Latif

Update Row Item only updates the DataTable in memory, not the Excel file.
After your For Each Row loop, use Write Range Workbook with varExcelResultDT to write the updated DataTable back to the same Excel file.

Example flow:
Read Range Workbook → Process rows / Update Row Item → Write Range Workbook (varExcelResultDT)

Alternatively, you can update the row using:
CurrentRow(“Status”) = “Successful”