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

 Sri K (Sri5777)
ExperienceIT

ExperienceIT
US
Sri5777 Member since 2017 7 posts
ExperienceIT
Posted: Aug 17, 2019
Last activity: Dec 26, 2019
Posted: 17 Aug 2019 13:11 EDT
Last activity: 26 Dec 2019 8:56 EST
Closed

Unable to get Range for Excel after filtering the data in it

Hi All,

I am trying to get the range of the visible cells in worksheet after filtering the values but unable to get the range. I have attached a sample automation where you can try for yourself and let me know if you found anything. I will update the post if I was able to get it.

Thanks in advance.

To see attachments, please log in.
Robotic Process Automation

Posted: 4 years ago
Posted: 26 Dec 2019 8:56 EST
Thomas Sasnett (ThomasSasnett)
MOD
Lead Robotics Architect
Pegasystems Inc.
US

I apologize for this going stale. I am looking at your sample solution, however it seems to rely on a specific Excel file as well as a few variables who's values are undefined. Would you please provide a little more details in addition to the instructions for getting this working? I'll be happy to take a look once you respond.

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