Hello,
How can I extract the Excel file attached to email. I want to create a workflow where workflow will access one particular email mailbox and take an Excel file as a data source from an email attachment.
Hi @patelbhavin, I have a workflow that I actually wrote a while ago (hence it still uses the legacy Python Script node), that can do part of what you are asking, if you have python installed.
For a particular task I periodically perform, I have a folder containing .msg (email) files and I have a need to extract any Excel attachments from them.
This workflow reads the folder that is configured in the List Files/Folders, and then the Python node loops through all the files that have been passed to it, extracting any Excel attachments to an “extract” subfolder which it creates below the input folder.
So although this doesn’t read the emails from the mail server, it can process emails if you can save them down to a local folder, which may be of assistance for the secondary part of the task.
Email Msg Attachment Extractor using Python.knwf (11.2 KB)
In terms of accessing the emails from the mail server, this is not something I have done with KNIME and I would imagine it will depend on what type of mail server you are using (e.g. Outlook or a pop3/imap server). The following from @qqilihq may be of help:
3 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.