Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

4
Replies
161
Views
Sulakkya Member since 2015 18 posts
Evonsys
Posted: Aug 20, 2020
Last activity: Sep 2, 2020
Closed
Solved

How do I get the used range of an excel connector?

I have used the excel component but I want to use the excel connector to automate a task. 

https://community.pega.com/video-library/how-configure-excel-range-automate

I'm struggling to find the used range (dynamic) of the excel.

To see attachments, please log in.
Pega Robotic Automation 19.1
Robotic Process Automation
Financial Services
Robotics System Architect

Posted: 4 years ago

there are two types of excel components. One is Microsoft Excel and ExcelConnector. MSExcel is used only for Excel files. ExcelConnector uses opensource and is where the range functionality resides. You will need to add that to your automation. 

To see attachments, please log in.

Related content:

Related content has not currently been identified for this post.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice