Gea Bergsma-Brander (GeaB4310)
Achmea Interne Diensten NV

Achmea Interne Diensten NV
GeaB4310 Member since 2018 1 post
Achmea Interne Diensten NV
Posted: December 14, 2020
Last activity: December 15, 2020
Posted: 14 Dec 2020 12:13 EST
Last activity: 15 Dec 2020 4:10 EST

Reading Data from Excel with more than 100 columns


I am working on a robot who needs to fill out a web form. In this form there are 107 possible questions. The answers to these questions are given in a Excelsheet. The robot reads this sheet and fills out the corresponding questions in the web form.

Normally I would loop through the rows to fill out the form. However the amount of colums is really high and I was wondering if there is an easier way to read the cells.

This is a one-time only robot which performs a bulk processing.


***Edited by Moderator: Pooja Gadige to add platform capability tag***
Pega Robotic Desktop Automation 19.1 Data Integration Robotic Process Automation