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***
I would read the entire Excel sheet into a DataTable (using the ExportData method). This will provide you with a DataTable that you could easily query against in a script rather than loop through and match everything. If you don't have any development experience (C# will be the language that the script would be written in), then you'll likely be limited to a simpler solution (that being iterating every row and checking the value).