if i understand correctly, you want to check if there is any empty cell in given column ?
You may have to use while loop for this.
r - row number, starting from zero
c - column number, starting from zero
You can read Whole column And using For each row you can iterate it. in the loop you can use If Activity and gives the condition in If “Row = Nothing” then perform the action action you want in then Section.
Thanks & Regards
I want to check if the next cell in A column is empty, then the program will stop.
As below picture is A4. What is the best command in If Activity to check this condition ?
Thanks so much!
I want to check the next cell empty… The command " Row = Nothing " to check all row right ?
you do not need loop here,
dt.select(“So Tk = ‘’”).length > 0
I hope you got the Whole “A” column. after that you can iterate it in for each row. in the for each row use IF activity give the condition “Row = Nothing” it will work for you.
Thanks & Regards
this topic is somewhat relevant to this.
Hi, I have met this error as below.
Please use the condition
row(0).ToString ="" in if activity.
Thanks you so much!
But which is activity to stop immediately program when it detect the next empty cell.
Thanks you so much always
with for each loop and checking next cell is empty
if empty it will write line and exits from loop.
find_empty.xaml (20.6 KB)
Let me know, if it requires modification
If you want to exit the iteration whenever a cell in the first column is empty , You can add a break activity in the ‘then’ section.
Thanks you. I understood
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.