I have to Check whether the excel have some Records/Data or not ? (Need to Determined using If -else)
E.g : Excel A
I have used the Read Activity and Set Variable as “Dt”
Then i took Assign Activity, with Variable “No_of_row”
If No_of_row >0 then
“Excel have some Value”
Send a Mail (Mail Activity) : " No Data"
But on else part i was getting error. When Excel is empty it is throwing Error. Can any one help on this one ?
Thanks in advance,