Question

17
Replies
12048
Views
PravinP2670 Member since 2016 2 posts
Synechron Technologies Pvt. Ltd.
Posted: 3 years ago
Last activity: 1 year 10 months ago
Closed
Solved

Loop through Excel data to fill forms on web page and create records in database - Openspan - Pega Robotic Automation

I have one excel(xlsx) with some data with column headers. I want to

Loop through the excel data -> take a row at a time -> fill web form for each row -> performClick on submit button to save data on website.

I used MicrosoftExcel connector to open the file. But I am facing some problems -

1. ExportData method take fromCell to toCell to export the data in datatable. How can I get the cell range as there may be any number of rows?

2. How can I loop through the DataTable returned from ExportData method? Tried forLoop, but not getting fit with the DataTable returned by ExportData function.

3. While looping through, how can I get the individual column values so that I can set values in web form fields one by one?

I would be thankful if anyone can help.

Thanks,
Pravin

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn