Question

17
Replies
12271
Views
Close popover
Pravin Pujari (PravinP2670)
Synechron Technologies Pvt. Ltd.

Synechron Technologies Pvt. Ltd.
IN
PravinP2670 Member since 2016 2 posts
Synechron Technologies Pvt. Ltd.
Posted: April 5, 2017
Last activity: October 16, 2018
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.