How to extract table data from mail body?

[Palaniyappan (Palaniyappan P)]

Hi

There are multiple approaches to read a DATATABLE from a mail body
Like data scrapping or converting the HTML mail body to DATATABLE

Have a view on this thread for multiple approaches

Extract table from email body

Hi developers, I have email as input for robot to be triggered. There is normal text as well as table included in the email body which I need to read for every trigger, some of the fields will be extracted from the email which will serve as input going further. Please help me extract table from which I need data for a couple of columns.

Or
This component can help you convert the HTML to datatable that is it will read the mail and give the datasets in it

HTML to DataTable - RPA Component | UiPath Marketplace | Overview

If you using this component
Then the steps involved will be like

In property HTMLText – item.Header(“HTMLBody”).ToString . This will extract the HTML code from the email and convert it into a string.

Cheers @BNK