I need to paste some data into an excel file that already contains data, have some way to check which field is empty and impute the data?
obs:I do not know until the row and column is filled
I need to paste some data into an excel file that already contains data, have some way to check which field is empty and impute the data?
obs:I do not know until the row and column is filled
You can do this check on a Loop (For Each Row activity).
With in that foreach, you will need an "If " activity to check: row.item(“ColumnName”).ToString() = “” or row.item(“ColumnName”) = nothing
If match found, assign the value in to that cell using Assign activity.
could you send me an example please?
I still have a hard time messing with uipath
tks