Question

1
Replies
199
Views
RyanL769 Member since 2018 8 posts
Avanade
Posted: July 17, 2018
Last activity: November 6, 2018
Closed

How to retrieve cell values from a large set of excel data (many columns)?

Is there a more simple way to get cell values from an excel spreadsheet than using a dozen getCellValue's inside of a forLoop?

I have a spreadsheet of data that has ~15 columns and ~100 rows. I need to process each row, retrieving the value under each column to be used within one of my automations. The only way I can think to accomplish this is to create a forLoop, and then have 15 getCellValue() blocks inside of it to represent each column... the problem with this is that it will take up a lot of space and is messy...

Is there an easier way to accomplish this?

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn