Just iterate through visable rows

[marco.roensch]

Hi guys Marco here,

My “for each row in data table” does iterate through every row of my Excel. Even through the non-visable / hidden ones.
I was wondering if I can filter my DT, so that it iterates only through my visable rows?

Thanks in advance!
Regards

[ppr (Peter Preuss)]

when using read range the resulting data table does not have such a flag

Have a look here as well

[marco.roensch]

Hi @ppr

i am using the classic Excel Application Scope:

So in this case I cant use the “Read Range” in Excel Activity you posted.

Is there another opportunity?

[ppr (Peter Preuss)]

you can use this construct