Row insertion in an Excel file

excel row insertion

Email&Parser can insert data from emails in an Excel file. It automatically creates a new row with the specified fields.

Note that old Excel files (.xls) are not supported. Only newer (.xlsx) Excel files can be used by Email&Parser.

For example, given the following email:

email wiht fiels to be parsed

We need to extract the fields customer, invoice and quantity and insert them in an Excel file. It can be done this way:

save email parsed fields to excel Fields retrieved from the email are inserted in new Excel row
Download this example
How to load example files

A little more advanced way is to process emails that can have multiple sets of cutomer,invoice and quantity. For example:

email wiht fiels to be parsed

It can be done adding an Iterator automated process before the Excel automated process:

multiple email parsed fields are saved to excel An email can contain multiple sets of customer, invoice and quantity. Insert each set in a new Excel row
Download this example