About datable with excel

hello everyone,I want to write to the blank cell ,filld with the row number and the id.
for example,if the line that id=3,I need to fill in the B4 with “4+3”.
And suppose I don’t know where is the blank cell.
Thank you very much

B5 cell fill with “5+4”

Hi @jmy,

Use dictionary & get empty space, then use write cell & write in that

HI @jmy,

Use Read Range activity to get the data to Data Table (dt).

Use For Each Row activity
inside use IF activity to check that value is empty or not
If True-> use Assign activity to update that value

Then use write range activity to update the data.


1 Like

Main.xaml (15.0 KB)

what if I don’t know the id?
thanks for your reply