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

 Ishara Wickramausrya (Ishara Derek)
Virtusa
Ishara Wickramausrya
Virtusa
US
Ishara Derek Member since 2015 17 posts
Virtusa
Posted: Jun 14, 2020
Last activity: Jun 14, 2020
Posted: 14 Jun 2020 2:42 EDT
Last activity: 14 Jun 2020 5:50 EDT
Closed

Read an Excel, CSV file from external location Using Java, without a listner

I want to figure out a way to Read an Excel,CSV File from external location, and get each row values on a pagelist property. It is better without using listner since it is only for OneTimeActivity. If possible using Java it would be better.

To see attachments, please log in.
Pega Platform 7.2.2
Case Management
Healthcare and Life Sciences
System Architect

Posted: 4 years ago
Posted: 14 Jun 2020 5:50 EDT
Saikat Chakrabortty (Saikat_Chakrabortty)
Capgemini
Pega Developer
Capgemini
IN

Yes, it is possible by Java. Please explore PRFile in pega engine api which let you access file from a directory. If you are dealing with excel and need more granular control apache POI comes OOTB with pega. 

 

-Saikat

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