Just iterate through visable rows

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 :slight_smile:

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

Have a look here as well
grafik

Hi @ppr

i am using the classic Excel Application Scope:
image
So in this case I cant use the “Read Range” in Excel Activity you posted.

Is there another opportunity?

you can use this construct

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.