About datable with excel

Help
1

image
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

2

B5 cell fill with “5+4”

3

Hi @jmy,

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

4

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
string.IsNullorEmpty(Convert.Tostring(row("name")))
If True-> use Assign activity to update that value
row("name")="A"+row("id").ToString()

Then use write range activity to update the data.

Regards,
Arivu

1 Like
5

Main.xaml (15.0 KB)

6

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