Question

2
Replies
3154
Views
Michael Tan (tanm1)
PEGA
Senior System Architect
Pegasystems Inc.
JP
tanm1 Member since 2016 39 posts
PEGA
Posted: March 28, 2017
Last activity: August 26, 2020
Posted: 28 Mar 2017 12:04 EDT
Last activity: 26 Aug 2020 8:41 EDT
Closed
Solved

Pega Robotics Studio 8: reading data from an Excel document of unknown rowcount

The MicrosoftExcel connector allows information in an Excel spreadsheet to be read into a DataTable through a call similar to the following:

However, it does not work as displayed - it only works if "cellEnd" is hardcoded to a value; if we set the value to one greater than the range which actually contains data we get an "assigning null value" error, but I can't find a "getUsedRange" function within the MicrosoftExcel component to tell up to what cell data is contained within.

Is there any way to get all of the data in an Excel workbook with data of unknown row and column count?

**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.

Robotic Process Automation
Moderation Team has archived post, 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.