Question 4 Replies 54 Views × Close popover Sulakkya Peiris (Sulakkya) evonsys Consultant evonsys LK View Profile Send Message Sulakkya Member since 2015 14 posts evonsys Posted: August 20, 2020 Last activity: September 2, 2020 Posted: 20 Aug 2020 5:34 EDT Last activity: 2 Sep 2020 15:11 EDT 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. Pega Robotic Process Automation 19.1 Robotic Process Automation Financial Services Robotics System Architect × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Posted: 7 months ago Posted: 20 Aug 2020 14:49 EDT × Close popover Michael Lambert (lambm) PEGA Sr. Manager, Pega Academy Pegasystems Inc. US View Profile Send Message lambm PEGA replied to Sulakkya 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. Posted: 7 months ago Posted: 21 Aug 2020 0:26 EDT × Close popover Sulakkya Peiris (Sulakkya) evonsys Consultant evonsys LK View Profile Send Message Sulakkya evonsys replied to lambm Yes, I'm aware of that. I want to know how to get the used range on 'Excel connector', as we would use 'WorkSheetGetUsedRange' method in microsoft excel component. Accepted Solution Posted: 7 months ago Updated: 7 months ago Posted: 21 Aug 2020 9:10 EDT Updated: 2 Sep 2020 15:11 EDT × Close popover Thomas Sasnett (ThomasSasnett) PEGA Lead Robotics Architect u2013 Pega Consulting Pegasystems Inc. US View Profile Send Message ThomasSasnett PEGA replied to Sulakkya It is possible to enhance the Excel Connector using an extension. I have attached one we've used before that was written by Jeff Badger. Posted: 7 months ago Posted: 2 Sep 2020 9:57 EDT × Close popover Sulakkya Peiris (Sulakkya) evonsys Consultant evonsys LK View Profile Send Message Sulakkya evonsys replied to Sulakkya Thanks, Thomas!