Question
4
Replies
734
Views
Mphasis Unleash the Next
IN
Posted: October 26, 2017
Last activity: November 8, 2017
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***
Posted: 5 years ago
Tata Consultancy Services (TCS)
CA
HI,
You can do this using script component.
Posted: 5 years ago
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: 5 years ago
Mphasis Unleash the Next
IN
Hi All,
any update on this thread?
Posted: 5 years ago
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.