Extract table from Outlook Mail body to Excel file

[shyamala_shyamu (shyams)]

Hi, I am trying to extract table data from multiple emails in Outlook and save it into a single Excel file. The steps I have followed are:

1. Saved the email attachments as .mht files.
2. Opened the .mht files in a browser (Edge) and used web scraping to extract the table data.
3. Used the ‘Merge Data Table’ activity to combine all the data tables into a single data table.

However, I want the final data table to exclude headers from all Data table and contain only the data rows. Could you please guide me on how to achieve this effectively

[ashokkarale]

@shyamala_shyamu,

If the table headers are being added to the datatable as rows then you can use Filter Datatable activity to remove those rows where column names are there.

This way clean the data and then write it to excel.

[shyamala_shyamu (shyams)]

@ashokkarale

Thanks for your reply.I have tried this but it’s not working .Kindly assist me.

[ashokkarale]

@shyamala_shyamu,

Ok. To understand it more clearly, can you show how the datatable currently looks like and how do you want it?

[shyamala_shyamu (shyams)]

@ashokkarale

The data table look like this,

I want to remove the Extra header rows in the 3,5.

[ashokkarale]

@shyamala_shyamu,

Have you filtered the datatable like this?

[shyamala_shyamu (shyams)]

@ashokkarale

Yes I tried the same

[shyamala_shyamu (shyams)]

@ashokkarale

Kindly help me in this.

[ashokkarale]

@shyamala_shyamu,

Try this LINQ in assign activity.

filteredDataTable = yourDataTable.AsEnumerable() _
    .Where(Function(row) Not row(0).ToString().Contains("Part Number")) _
    .CopyToDataTable()

[shyamala_shyamu (shyams)]

@ashokkarale

Tried this but it’s not working…

[ppr (Peter Preuss)]

@shyamala_shyamu

I am trying to extract table data from multiple emails

also have a look the different packages e.g. offered at Marketplace

HTML to DataTable - RPA Component | UiPath Marketplace | Overview

[shyamala_shyamu (shyams)]

@ppr

Thanks for your responce.I will check it.

[shyamala_shyamu (shyams)]

@ashokkarale

It’s working.Thank you so much for you help.