I have the excel where I need to check if we have missing value in the column “Profit”. The missing value is denoted by a “?” as shown below. I then need to replace the value “?” only in the “Profit” column by the value in the “Total” column.
Can anyone help me please?
UIPath_Excel_Scratch (4).xlsx (20.2 KB)
ExcelProcess.zip (53.8 KB)
Mark as solution if this help you
use read range activity to store this entire data into a datatable. Now for each row, check if row.item(“Profit”).ToString() = “?”, then assign row.item(“Profit”) = row.item(“Total”)
Welcome. You can write the datatable back to excel sheet after these modifications. Hope it helped you.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.