Extract Table for a Body email

Help
1

Hi,
I am trying extrat a table for a body email.

I have looked for similar problems in the forum, but I have not found anything that can solve it. I have tried to extract the body from the email as html, but I am not able to access each cell.

I must bear in mind that the cells may have content, but other times they may be empty.
I do not know if there is any way to extract the table as .csv or how I should handle it in order to access the values ​​located in each cell.

image
image728×127 2.4 KB

Thank you

2

Try scrapping…

3

Use DataScraping Option From the Ribbons To Extract the table

Note: You firstly Need to open the Email in browser (recomeneded IE).

4

I cant open Email in browser. I don’t have access to it.
I use activities exchange email to read it. And need download o get data from a table inside body.

I have managed to download the email in a .html
But I am not able to scrap the entire table.

5

Okay So,In this Case You have to use String manipulation techniques and some regex to extract the related information.

Store Mail.Body As a String And do string manipulation in it .

6

Try this:

7

Custom activity to extract tables from email:
https://go.uipath.com/component/extract-tables-from-mail-839f39
It takes mailmessage as an input and returns a dataset with all the table content in the email.