Question
Last activity: 9 Dec 2019 20:25 EST
How to upload Excel file data to Clipboard
Hi All,
How to upload/extract Excel file data to Clipboard so that i can repeat that using page list.


Pegasystems Inc.
IN


Pegasystems Inc.
IN
Hi,
The below link explains the activity to read from CSV to the clipboard.


Pegasystems Inc.
IN
Hi Sudheer,
Not sure what your exact requirement is but below is one of the suggestions that can be used if you want to have the excel data in the clipboard (not uploading the excel data at runtime) :
- Create a Data Type with the properties that you want to be populated with the excel.
- Import the data from the excel (you will get the option to map the properties with the columns in excel while importing).
- Once you have created a Data Page and imported the data you will be having the data in the local and a Data Page of type Page List (which gets created by default). This data page can be used in your use case.
Regards,
Vikash
Hi Vikas,
Thanks for the suggested approach, I can achieve with your solution, I am mostly trying to get this work using "pxUploadCSVResults" Flow action.
I'm getting Null Pointer Exception inspite passing the Page name dynamically to the Activity(pxUploadCSVResults) after customizing. But the results are negative. Any suggestions please..


Pegasystems Inc.
IN
Could you please add the screen-shots showing what modification you have done and also provide the complete stacktrace from Pega-RULES log file.
Hi,
Please check the below link. It might help you.
https://community1.pega.com/community/product-support/question/help-how-import-csv-pega-clipboard-and-export-csv-pega-clipboard