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

[HarishM2]

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
------------------------------

[james.man]

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
------------------------------