Skip to main content
Contact a Moderator

Question

4
Replies
729
Views
 Suresh Mettu (SureshM5078) Mphasis Unleash the Next
Mphasis Unleash the Next
IN
SureshM5078 Member since 2017 10 posts
Mphasis Unleash the Next
Posted: October 26, 2017
Last activity: November 8, 2017
Posted: 26 Oct 2017 7:23 EDT
Last activity: 8 Nov 2017 19:04 EST
Closed

Excel Range

Report

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***

Robotic Process Automation
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: 4 years ago
Posted: 26 Oct 2017 9:15 EDT
Antara Chatta (AntaraC5) Tata Consultancy Services (TCS) Solution Architect- Pega Robotics
Tata Consultancy Services (TCS)
CA

HI,

You can do this using script component. 

 
Posted: 4 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.
Posted: 4 years ago
Posted: 8 Nov 2017 19:04 EST
Andrew Grondin (grona) PEGA 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.

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