Question4Replies1541Views RajagopalR9783 Member since 2018 1 post Pacific Dental Services Holding Company Inc Posted: 2 years agoLast activity: 1 year 5 months ago 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-rob… 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.