Question4Replies1612Views×Close popoverRajagopal R (RajagopalR9783) Pacific Dental Services Holding Company Inc Pacific Dental Services Holding Company Inc US View ProfileSend Message RajagopalR9783 Member since 2018 1 post Pacific Dental Services Holding Company Inc Posted: July 6, 2018Last activity: April 1, 2019Posted: 6 Jul 2018 1:01 EDTLast activity: 1 Apr 2019 8:21 EDT 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 agoPosted: 6 Jul 2018 22:54 EDT×Close popoverAndrew Grondin (grona) PEGA GCS Solutions Engineer I Pegasystems Inc. US View ProfileSend Messagegrona 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 agoPosted: 9 Jul 2018 0:49 EDT×Close popoverJayachandra Reddy (Jayachandra Reddy K) Infosys Infosys IN View ProfileSend MessageJayachandra 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 agoPosted: 10 Jul 2018 8:40 EDT×Close popoverSelvashankar Palanisamy (SelvashankarP) Cognizant Cognizant IN View ProfileSend MessageSelvashankarP 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 agoPosted: 1 Apr 2019 8:21 EDT×Close popoverNaresh K (NareshK6160) Ford Ford US View ProfileSend MessageNareshK6160 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.