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

 Ravi Kumar Pisupati (Mr. Ravi Kumar Pisupati)
GovCIO
Pega Lead Solutions Architect
GovCIO
US
Mr. Ravi Kumar Pisupati Member since 2024 90 posts
GovCIO
Posted: Nov 8, 2018
Last activity: Nov 15, 2018
Posted: 8 Nov 2018 13:31 EST
Last activity: 15 Nov 2018 2:46 EST
Closed

What is the best approach to read & parse data from a xls file using FileListener?

Hi,

We are using PRPC V7.2.2 and we have a requirement like we will get a big excel file from biz. We would like to parse that excel file using File Listener and store the data into DB tables. Currently we have an existing functionality for a csv file using File Listener and would like to leverage the same thing using xls file. What are the steps to fulfill this requirement? I am not sure whether we can convert the xls file into csv format first before parsing it using File Listener or is there any best approach without conversion. Please let me know your thoughts.

Thanks,

Ravi Kumar Pisupati.

***Edited by Moderator Marissa to update platform capability tags****

To see attachments, please log in.
Low-Code App Development
Dev/Designer Studio

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