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

 Annapurna Kalidindi (AnuP3667)
TD Bank
Solutions IT Designer Pega
TD Bank
CA
AnuP3667 Member since 2018 14 posts
TD Bank
Posted: Jan 19, 2019
Last activity: Jan 21, 2019
Posted: 19 Jan 2019 1:43 EST
Last activity: 21 Jan 2019 7:25 EST
Closed
Solved

populate textboxes from excel

I have a requirement where I need to populate the excel row values to their respective textboxes. I am getting the values from getitem into message box. But how can I populate the values from row to their respective textboxes? Please help me with the solution.

Thanks & Regards,

Anu

To see attachments, please log in.
Robotic Process Automation

Accepted Solution

Posted: 5 years ago
Posted: 19 Jan 2019 4:16 EST
Jayachandra Reddy (Jayachandra Reddy K)
Infosys

Infosys
IN

You can export excel data to datatable using exportdata and then loop the datatable rows and read required row values or you can use excel getcellvalue method for each cell.

for ex: if you want read first row values then pass A1, B1, C1 to getcellvalue method based on no of cells.

To see attachments, please log in.

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