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?
Pegasystems Inc.
US
You may use the ExportData method to retrieve a DataTable object representing the values of each of the cells in the range you provide. With the DataTable object, you could pass it into a script to process it in C# to read the values that you need. You can also work with the DataTable in an automation using Proxies, but that will be a little slower to process.