Question4Replies41Views Sulakkya Member since 2015 14 posts evonsys Posted: 2 months agoLast activity: 1 month 2 weeks ago 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-automateI'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 popoverFacebookTwitterLinkedinEmail Copy Link Copied! Posted: 2 months agolambm PEGA replied to Sulakkyathere 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: 1 month agoSulakkya evonsys replied to lambmYes, 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: 1 month agoUpdated: 1 month agosasnt PEGA replied to SulakkyaIt 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: 1 month agoSulakkya evonsys replied to SulakkyaThanks, Thomas!