topic Re: How to read downloaded htm files and extract required data? in Product Forum

How to read downloaded htm files and extract required data?

Scar — Fri, 01 Oct 2021 05:14:05 GMT

Hi all ,

I am new to BP. I want to read a downloaded htm file on my pc and then want to extract required data from its tables .
I can store the extracted data into data items and use it later.

Currently i am unable to do so .

Please help

Thank you

Re: How to read downloaded htm files and extract required data?

ewilson — Fri, 01 Oct 2021 11:58:46 GMT

Hello @Scar,

Have you considered spying the web page instead of downloading and trying to parse the HTML yourself? You might take a look at the Browser Automation Guide too.

https://blue-prism.docebosaas.com/learn/course/198/play/1581/Browser%2BAutomation%2BGuide

Cheers,
Eric

Re: How to read downloaded htm files and extract required data?

RameshG_J — Fri, 01 Oct 2021 12:28:09 GMT

Hello Scar,
Since you mentioned that you have the htm file in PC launch any browser and use the navigate stage to pass the file location as URL. After this use the browser automation to spy the table. You can use the read stage and using the Element which you have spied for the table you can save the data as datatable.

Hope this helps