I have an excel file with multiple columns and rows. I am trying to replace the row value after the click activity From “incomplete” to “completed”. how do i update it ? . For example
In columns “A” rows 15 “Somevalue” . then i want to replace “incomplete” value to "completed in same rows but in different columns say in “K” rows 15.
Hello @whitestar,
There are two possible ways to update the status column while complete the process.
1 . Update in DataTable
Use Assign activity to update the column in the DataTable.
Like
At last, export your DataTable to your local.
But method is not Appreciated. Because this method will update the value only in DataTable(UiPath Memory). In case any problem occur in the machine while running the bot, the whole data was erased.
Update in Excel
Use Write Cell Activity to Update the value into Excel File.