Excel Tables - Row's count

[irmscher]

I'm using row's count function to check the amount of rows in excel table and then compare it with current row (variable) in order to be able to stop the script when all the rows in table had been used.

Sometimes it works but sometimes script start picking blank rows.

I've checked in debug and for some strange reason Row's count function sees more rows than exist, may be it happens when you delete some of rows?

So I need to make the script stop when thre's a blank row but script sees blank rows as rows with some data for some strange reason...

 

[irmscher]

Anyone?

 

[rostonix]

You can check if taken data is empty with IF action:
'{-Variable.yourvariable-}'!=''
If true there's something taken.

 

[Hungry Bulldozer]

You can act this way:


Send an example of non working one to support email.

 

[irmscher]

You can check if taken data is empty with IF action:
'{-Variable.yourvariable-}'!=''
If true there's something taken.

Yeah, right, I forgot about "!=" and didn't know you can identify blank with ' '



Thanks, it works!