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