JY
Either u can use Write Range or write Cell
If condition
currentrow.item(1).tostring is string.empty
Then else
currentrow(2)= "male"
Size: a a a
2022 January 12
SK
KA
It can be used
SK
That condition not working why ? 👆👆
JY
If
Currentrow("Gender").tostring is Nothing
Currentrow("Gender").tostring is Nothing
SK
Is string.empty not working ? Why ?
KA
This one is correct condition
JY
U can use this also -
If
Currentrow("Gender").tostring = ""
If
Currentrow("Gender").tostring = ""
SK
Why can't we use assign activity in then or else why only write cell activity?
JY
By using Assign will update the dataTable not excel file
SK
Oh ok
M
Yes
JY
We can update the datatable using assign activity and at the end of the process u have to use Write Range to update the excel.
M
Currentrow("column name").tostring
SK
SK
SK
Is it correct ? It's not working
M
="value u are looking for"
SK
If its empty then write cell value there that's it
M
