How to read range only unhidden rows in excel

Help Studio
1

I have this one excel file that I append my new entries into. After processing this new rows, I would hide it and wait for new rows to be added. Problem is, when I am trying to read range the table, it would also read the hidden rows(hidden from previous runs), Is there a way to read range only the unhidden rows? Thank you.

1 Like
2

Hello @Raffy,

I do not know exactly how to read an excel without hidden rows, but maybe when robot processess the rows, write in a column something like “Proceeded” and then when processing new lines, filter by empty rows in column in which are “Proceeded” status.

I am sure you prefer your option, but I just wanted to suggest another option :slight_smile:
Regards

3

There was a question about this issue, maybe it helps you:

4

Was gonna do this before. Too bad my client already signed our proposed process design. But if we got really no choice, I’ll push this solution. Thanks for Replying btw.

1 Like
5

Hi

We can just do that by enabling UseFilter property in READ RANGE activity
That will give only the filtered - unhidden rows

Cheers @Raffy

2 Likes
6

Thank you very much! Didn’t know about this part in Read range.

1 Like
7

Happy automation @Raffy

8

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