Extract table from Outlook Mail body to Excel file

Help Studio
, ,
1

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

2

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

3

@ashokkarale

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

4

@shyamala_shyamu,

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

5

@ashokkarale

The data table look like this,

image
image620×633 18.3 KB

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

6

@shyamala_shyamu,

Have you filtered the datatable like this?

The image shows a "Filter Wizard" dialog for filtering rows and columns of a DataTable, where rows containing a specific part number are set to be removed. (Captioned by AI)
The image shows a "Filter Wizard" dialog for filtering rows and columns of a DataTable, where rows containing a specific part number are set to be removed. (Captioned by AI)674×472 25.2 KB

7

@ashokkarale

Yes I tried the same

8

@ashokkarale

Kindly help me in this.

9

@shyamala_shyamu,

Try this LINQ in assign activity.

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

@ashokkarale

Tried this but it’s not working…

11

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

12

@ppr

Thanks for your responce.I will check it.

13

@ashokkarale

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

1 Like
14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.