Question
Loop through Excel data and fill data in Web forms
Hello All, I am new to open span and trying to build automation for the below scenario. Please suggest.
1. Excel file will come as an email attachment.
2. Automation should take that excel from the email and check every row.
3. We have a validation logic. When iterating through every row, If the validation is true then only we need to submit that row details in a web form.
4. If validation logic fails we need to reply back to sender.
Thank you so much for your help,
Rajesh
Thank you Jeff for the quick response. I referred both posts and i am able to save my email attachments in a folder.
Only Part i am stuck here is
1. How to pick up the excel, if i have multiple attachment.
2 Would it possible to pick the excel from a specific folder.
Thank you,
Rajesh
There are many posts here that can help you do this. Using the search feature here are a couple that can help.
Download attachments
Excel How To