Question

1
Replies
448
Views
Close popover
Ravi Kumar Pisupati (Ravi Kumar Pisupati)
Optum
Principal LSA - Pega
Optum
US
Ravi Kumar Pisupati Member since 2015 83 posts
Optum
Posted: November 8, 2018
Last activity: November 15, 2018
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****

Low-Code App Development Dev/Designer Studio
Moderation Team has archived post