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

3
Replies
784
Views
 Harika Chadalawada (HarikaC9973) BankOfAmerica
BankOfAmerica
US
HarikaC9973 Member since 2017 5 posts
BankOfAmerica
Posted: June 28, 2017
Last activity: June 29, 2017
Posted: 28 Jun 2017 0:38 EDT
Last activity: 29 Jun 2017 12:02 EDT
Closed

How to set cell value in excel given row and column index

Report

Hi, I am trying to set cell value in excel using row and column index. For example, cell(1,2) [row 1 and column 2] has to be populated with a value. Is there a possible way to do this rather than doing a macro. Please advise.

***Moderator Edit: Vidyaranjan | Updated Categories***

Robotic Process Automation
Posted: 5 years ago
Posted: 28 Jun 2017 6:10 EDT
Jeff Badger (jeffbadger) PEGA Principal Product Manager, Robotics
Pegasystems Inc.
US
Report

Using the Excel connector you can do this using the SetCellValue method.  It excepts a cell address.
Posted: 5 years ago
Posted: 28 Jun 2017 10:59 EDT
Harika Chadalawada (HarikaC9973) BankOfAmerica
BankOfAmerica
US
Report

Jeff,

I can pass a cell name like C16 to setcellvalue method. However, as mentioned earlier I have a for loop that returns row and column index like 2 and 3 which means row 2 and column 3. I don't see a method available for excel connector that takes row and column values as parameters. Any ideas.

Thanks !

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