Question
4
Replies
690
Views
Mphasis Unleash the Next
Posted: October 26, 2017
Last activity: November 8, 2017
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: 3 years ago
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: 3 years ago
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.
HI,
You can do this using script component.