Question
4
Replies
44
Views
Posted: August 20, 2020
Last activity: September 2, 2020
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.
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.