Need a efficient way to load web table data into collection

[ZhimingLiu]

Is there any way to load table data into a collection in a efficient way?

------------------------------
Zhiming Liu
------------------------------

[GopalBhaire]

Hi,

Is this a web application? If yes you can spy the whole table and use read items to get data in collection. 

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

[KristaJames · Accepted solution]

I recently learned that you can also spy one field of the table, then in your 'Read' stage for that 'Element' choose the Data option 'Get Table'.  It brings the table (and possibly some blank columns and rows) into a collection.  I happened to use this in SAP Ariba, but the poster I learned it from didn't say what they were using.

------------------------------
Krista James
Solution Designer
The Boeing Company OIG&A
America/Los_Angeles
------------------------------

[NileshJadhavBP]

Great 🙂

You can use remove blank row action to remove blank from collection.

Thanks
Nilesh

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------