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

 Suresh Mettu (SureshM5078)
Mphasis Unleash the Next

Mphasis Unleash the Next
IN
SureshM5078 Member since 2017 10 posts
Mphasis Unleash the Next
Posted: Oct 26, 2017
Last activity: Nov 8, 2017
Posted: 26 Oct 2017 7:23 EDT
Last activity: 8 Nov 2017 19:04 EST
Closed

Excel Range

Hi Team,

i am using PEGA Robotics and want to select a particular range of cells in an excel sheet(I do not want to use the UsedRange, I want to select a range of my choice)and then select format cells to that particular range.

Please guide me on the above.

Thanks in advance.

***Updated by moderator: Lochan to add Categories***

To see attachments, please log in.
Robotic Process Automation

Posted: 7 years ago
Posted: 27 Oct 2017 4:20 EDT
Suresh Mettu (SureshM5078)
Mphasis Unleash the Next

Mphasis Unleash the Next
IN

Hi,

Thank you for the quick response,

may i know is there any other way i.e. using any other PEGA components other than script.

To see attachments, please log in.
Posted: 7 years ago
Posted: 8 Nov 2017 19:04 EST
Andrew Grondin (grona) GCS Solutions Engineer I
Pegasystems Inc.
US

Getting the cell value can be iterated through with a loop and the getcellvalue() method, but changing the format of a cell is going to require a macro in Excel.

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