A condition is a check from the last text of column i.
Then show the value 3
Use Read Range and store output in Dt
Give range as per your convenience if you want for Column “I” then type “I:I”
and then use DT.Rows.Count+1 will give “3”
Data Type will be Int
If you want it as string then use
I changed to Int but the resulting value is 1048576.
is there any data in “I” Column
Yes, I have information.
Please check the workflow attached,
Rowcount_Excel.zip (24.9 KB)
Please check this post might help you,
Use below query in assign activity to get row count
Dt.AsEnumerable().where(Function(x) not string.IsNullOrWhiteSpace(x(“Status”).ToString)).ToArray().Count+1
Hi. It should actually work when you just empty the range area field.
@Latika10011740, Thank you so much for your help.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.