Question
TCS
US
Last activity: 23 Jun 2017 13:03 EDT
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
Pegasystems Inc.
US
There are many posts here that can help you do this. Using the search feature here are a couple that can help.
TCS
US
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