Hi @NayanaH_P,
In order to read a table from a website, you first need to spy the table element in such a way that the entire table boundary is spied. If you did that you would see in the Path attribute you should get, '
' attribute at the end as shown below:
Once you are able to get this then you can simply use a 'Navigate' stage and use the action 'Get Table' which and assign a Collection to store the table results as shown below:
Once you have it in collection, this action can be called from your Process Studio considering you create a business object to hold this logic. And in your process studio, once you have generated the collection, you can use the 'Excel VBO' business object to sequentially call a set of actions: Create Instance, Create Workbook, Write To Collection and Close Instance (keeping the save flag as True)
Some times tables may not be easy to extract if they are not present in a HTML TABLE structure but rather they are present in terms of other tags such as DIV. In such cases you can't spy those elements directly as table, hence in such cases you might have to spy a specific cell in the table and see if there is a pattern in the path of that variable. Once you figure out the pattern, you can use a counter variable to make the path attribute dynamic and pick out values one by one and create a collection yourself. A good example of such use cases is given in this training session in Blue Prism University: Blue Prism® Modern Browser Automation: Working with HTML elements
------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future
Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.
