After my robot reads the file and does things with the data I want it to change/replace a word in an column in a row.
Example: The data is about new customers, It fills the data in to a form. If the data is in the form I want to replace de column ‘New customer’ → Yes to No. Because the robot only reads customers with the column ‘New customer’ with Yes.
Use an assign activity: row(columnIndexNo) = “No”, assuming you have the row and know the column index.
I get that but I want tot replace it in my Excel file.
Use can use the Excel WriteCell activity. The range of the cell would be rowIndex + 1:columnLetter.
Or you can update the datatable and replace the excel content.