Hello @anorden and welcome back to the community!
Okay, so you want to change the values in the currently opened excel file.
- Excel Application Score
Read Range > Get the DataTable
- Now in the SAME application scope (we are not closing excel file) we are using For Each Row activity
- Using Row values, String manipulation, and regex you can now change values and store them (Maybe Replace activity)
- Now, use Write Cell activity to Rewrite the value in the currently opened Excel file.
Inside Write Cell activity you need to put the new value in the place of old one.
Your Write Cell activity should look something like
The red square is the Row + current index
The purple square is the changed value.
I’m am sorry that I cannot do it more, but with this I think you can do it!