Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Prachi Dalvi (PrachiD5)
Ford Motor Company

Ford Motor Company
US
PrachiD5 Member since 2019 3 posts
Ford Motor Company
Posted: Apr 26, 2019
Last activity: Apr 29, 2019
Posted: 26 Apr 2019 15:54 EDT
Last activity: 29 Apr 2019 6:06 EDT
Closed

Needhelp finding WorksheetGetUsedRange under the methods for my excel connector

Hi,

I cant find WorksheetGetUsedRange under the methods for my excel connector, my Pega version is - 8.0.1089.0. Is there someway I can get this my system, or any other way that I can get the range of the excel sheet.

To see attachments, please log in.
Robotic Process Automation

Posted: 5 years ago
Posted: 27 Apr 2019 15:01 EDT
Naresh K (NareshK6160)
Ford

Ford
US
Use Micorosoft Excel Connector. Give the maximum limit of forloop say 10000 or maximum number. With the help of StringUtils concat and isnullorempty methods you can get the last used row.
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice