topic RE: MS Excel VBO how to read filtered rows? in Product Forum

MS Excel VBO how to read filtered rows?

jamesli000 — Wed, 16 Mar 2022 03:36:00 GMT

Hello Everyone

I am new to Blue Prism. I have a excel like this.
1
2
2
3

If I open this excel, it is filtered by 2 so only 2nd and 3rd can be saw.
But I use MS Excel VBO to read the worksheet but get all data of all rows .

Any method to get filtered rows (value = 2) user filter on Excel?

BR
James

------------------------------
James Li
------------------------------

RE: MS Excel VBO how to read filtered rows?

ewilson — Wed, 16 Mar 2022 03:55:00 GMT

Hi @James Li,

I don't recall if there's an option to filter using one of the actions on the VBO, but what you could do is use the Get Worksheet as Collection action and then apply your filter to the Collection.

There's information about filtering a Collection in this thread.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: MS Excel VBO how to read filtered rows?

RaivisLazdāns — Tue, 22 Mar 2022 14:35:00 GMT

Hi James,

In case of getting data from MS Excel I would suggest to use Data - OLEDB object and do SQL query where filtering criterions are applied. This would bring more stability.

Best regards,
Raivis

------------------------------
Raivis Lazdāns
Lead Process analyst/ RPA developer
Europe/Riga
------------------------------