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

 Veeraragavan Jayaraman (VeeraragavanJ) User Experience Designer
Tata Consultancy Services
GB
VeeraragavanJ Member since 2015 4 posts
Posted: Jan 8, 2021
Last activity: Jan 26, 2022
Posted: 8 Jan 2021 7:55 EST
Last activity: 26 Jan 2022 8:14 EST
Closed

Copy cells from excel and paste into text fields in Pega

Hello,

I have a scenario, where the user have to copy 4 cells from an Excel sheet and past it in the form (Pega -UI).

I have four fields (in Pega UI) named same as per the four cells in the excel sheet.

I want the user to copy the four cells from Excel sheet, come to Pega UI form, click the first field and do paste function so that the other 3 cells also get pasted.

Any OOTB feature available?

Alternate options could be considered.

 

Thanks

Veeraragavan 

To see attachments, please log in.
Pega Platform 8.3
Case Management
Financial Services
Experience Designer

Posted: 3 years ago
Posted: 13 Mar 2021 19:04 EST
Matthew Osborn (mjosborn85)
Jabil
Finance BPM Mgr
Jabil
US

@VeeraragavanJ , I'm currently looking for an updated answer to this, too. However, several years ago in Pega 6 I wrote a funny little component to display a text box in a modal dialog into which the user pastes values copied from Excel (header included). A very generic process then populates a page list. It then refreshed the grid to display the "paste".

There was even an option to use a data transform to consume denormalized data to create multiple objects with lists populated. It was very klunky compared to just pasting into the grid, but it was widely used across the company.

To see attachments, please log in.
Posted: 3 years ago
Posted: 15 Mar 2021 3:22 EDT
Tashika Shrestha (TashikaS)
PEGA
Principal Technical Support Engineer, User and Product Experience
Pegasystems Inc.
IN

@VeeraragavanJ

Can you check the below links with similar doubts

https://collaborate.pega.com/question/pega-rpa-can-someone-help-us-how-copy-excel-range-and-paste-it-other-excel-file

https://collaborate.pega.com/question/excel-copy-cell-value-and-write-another-cell

 

 

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