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

 Sriram Vellanki (SriramV1) Ernst & Young LLP
Ernst & Young LLP
US
SriramV1 Member since 2017 14 posts
Ernst & Young LLP
Posted: Apr 19, 2017
Last activity: Jun 27, 2017
Posted: 19 Apr 2017 14:31 EDT
Last activity: 27 Jun 2017 19:48 EDT
Closed
Solved

Excel Cell/Column Updates

Report

Hi,

I am using Excel Connector. How to update cell/column values?.

Thanks

Sriram

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

Robotic Process Automation
Posted: 6 years ago
Posted: 20 Apr 2017 5:39 EDT
Lochana Durgada Vijayakumar (Lochan_DV) PEGA Senior Manager, Knowledge Management
Pegasystems Inc.
IN
Report

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

Posted: 6 years ago
Posted: 20 Apr 2017 6:59 EDT
Jeff Badger (jeffbadger) PEGA Principal Product Manager, Robotics
Pegasystems Inc.
US
Report

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.
Posted: 6 years ago
Posted: 26 Jun 2017 15:21 EDT
Dinakara Prasad Hasthi (HDP_RPA01) Accenture
Accenture
US
Report

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.
Posted: 6 years ago
Updated: 6 years ago
Posted: 27 Jun 2017 3:59 EDT
Updated: 27 Jun 2017 4:04 EDT
Lochana Durgada Vijayakumar (Lochan_DV) PEGA Senior Manager, Knowledge Management
Pegasystems Inc.
IN
Report

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,
Posted: 6 years ago
Posted: 27 Jun 2017 19:48 EDT
Dinakara Prasad Hasthi (HDP_RPA01) Accenture
Accenture
US
Report

Thanks Lochana for the details. I was able to automate excel copy and write into another cell.

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