Excel Cell/Column Updates
Hi,
I am using Excel Connector. How to update cell/column values?.
Thanks
Sriram
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Pegasystems Inc.
US
The Excel connector has GetCellValue and SetCellValue methods. You should set the Worksheet property as well to be sure you are updating or reading from the correct Worksheet.
Pegasystems Inc.
IN
Hi Sriram,
Is your query on Pega Robotics? If yes, this blog is a must read! I belive you will find your answer here - Pega Robotics - Excel How To
If not, let us know back here!
Thank you!
Accepted Solution
Pegasystems Inc.
US
The Excel connector has GetCellValue and SetCellValue methods. You should set the Worksheet property as well to be sure you are updating or reading from the correct Worksheet.
Accenture
US
Hi Sriram - I'm new to PEGA robotics studio and trying the excel data copy to another excel sheet. Tried GetCellValue and SetSellValue methods in automation. However nothing is happening. Not sure if I'm missing something.
Could you please share the solution if that worked for you.
Updated: 27 Jun 2017 4:04 EDT
Pegasystems Inc.
IN
Hi Dinakara,
Thank you for posting your query on PSC. Have you checked out this blog post yet? Since you are new, this article and its subsequent replies could be of great value: Pega Robotics - Excel How To
In case you have questions after reading through the blog, please reply over the blog post or create a new post on our community by clicking Write a Post.
I also noticed that you have posted a similar question and its been Answered: Excel Copy cell value and write into another cell
Regards,