Outlook to Excel Assistant

This bot is designed to fetch the table content from the email body and convert it to an Excel workbook. It will then be saved to the OneDrive account

Top Benefits

Used to save the extracted HTML table from email body to OneDrive folder as an excel workbook
Use email body containing multiple tables

Tasks

Bot will fetch email filter conditions from config file
Loops through each mail according to the user preference (read/unread/all) and filter required emails
If all the filter conditions match, bot save the email body containing html table to local device path as html file
The html table is then converted to csv file by using the python package
CSV file then converted to Excel workbook and uploads to OneDrive account

The Outlook to Excel Assistant is used for any organization which fetches table content in an email body and creates an Excel workbook which can be saved to OneDrive. The config file is used to get filter conditions from the email and loops through each email accordingly. The bot will save the HTML file if all the conditions are matched and convert the HTML table into a CSV file using the Python package. The converted CSV file will create an Excel workbook and will save it to OneDrive