Question
4
Replies
1711
Views
Pacific Dental Services Holding Company Inc
Pacific Dental Services Holding Company Inc
US
Pacific Dental Services Holding Company Inc
Posted: July 6, 2018
Last activity: April 1, 2019
Last activity: 1 Apr 2019 8:21 EDT
Closed
OpenSpan :: Getting excel row count dynamically
Hi,
Could you please help to get the count of row in excel sheet dynamically using excel connector?
Thanks
Rajagopal R
Posted: 3 years ago
PEGA
Pegasystems Inc.
US
You would want to use a loop to cycle through the rows until you find a row that is blank.
Posted: 3 years ago
Infosys
Infosys
IN
Using excel connector and loop may be time consuming process. Use script to get the count dynamically.
Posted: 3 years ago
Ford Motors Private Limited
Ford Motors Private Limited
IN
If you still wanted to achieve without script.. you can get started with proxy items. refer https://collaborate.pega.com/discussion/pega-robotics-excel-how
Posted: 2 years ago
Ford
Ford
US
Use the ExportToTable method of ExcelConnector and extract proxy which you have DataTable. Now you can get the count of Rows and Columns.