How to extract table information in html Table ( from Outlook email) to Collection?

HarishM2 — Thu, 11 Jun 2020 19:35:00 GMT

Hello,

I'm able to convert outlook email to html but trying to figure out how to convert this html table data to datatable or collection ?

Basically If you look in to the below example "Email " And the table column for "TestInfo" rows are constant and the column "values" rows are dynamic.

I want to get this table in to collection because I want to get the values of each rows. Is it possible to convert html to collection in blue prism?

Example : Email

Hello,

Below is the table information

TestInfo	Values
ABC	1231Test
CDE	2322
FGH	242
GFG	fsfdf
JHJ	78adad
TYU	7ss
YUT	87ss

Thanks

------------------------------
Harish
RPA Developer
------------------------------

RE: How to extract table information in html Table ( from Outlook email) to Collection?

james.man — Tue, 16 Jun 2020 10:04:00 GMT

One thing you could try is to save the email as an HTML file in a temp folder on the local Runtime Resource, then open that email in Internet Explorer. Then you could spy the table using Browser Mode and extract the table as you would any webpage.

------------------------------
James Man
Professional Services
Blue Prism
Asia/Hong_Kong
------------------------------

topic How to extract table information in html Table ( from Outlook email) to Collection? in Product Forum

How to extract table information in html Table ( from Outlook email) to Collection?

RE: How to extract table information in html Table ( from Outlook email) to Collection?