Question4Replies1579Views RajagopalR9783 Member since 2018 1 post Pacific Dental Services Holding Company Inc Posted: July 6, 2018Last activity: April 1, 2019 Closed OpenSpan :: Getting excel row count dynamicallyHi,Could you please help to get the count of row in excel sheet dynamically using excel connector?ThanksRajagopal R Robotic Process Automation ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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. Posted: 2 years agogrona PEGA replied to RajagopalR9783You would want to use a loop to cycle through the rows until you find a row that is blank. Posted: 2 years agoJayachandra Reddy K Infosys replied to RajagopalR9783Using excel connector and loop may be time consuming process. Use script to get the count dynamically. Posted: 2 years agoSelvashankarP Cognizant replied to RajagopalR9783If you still wanted to achieve without script.. you can get started with proxy items. refer https://community1.pega.com/community/product-support/question/pega-robotics-excel-how Posted: 1 year agoNareshK6160 Ford replied to RajagopalR9783Use the ExportToTable method of ExcelConnector and extract proxy which you have DataTable. Now you can get the count of Rows and Columns.