I would like to find the empty cells in each row of an Excel table and update them with a new Excel table. The Excel spreadsheet has exactly the same header structure and also contains a primary key.
I can update a whole table, but unfortunately I only need the empty cells filled in.
Can you help me with this problem?
I think you can follow below steps to implement that.
1.Read data table from your output Excel table.
2.For each row to locate each empty cell, and set value to each empty cell.
3.Write back the data table to your output Excel table.
do you have an example for me? I don’t know how to locate an empty cell in Uipath.