Question

1
Replies
385
Views
Ravi Kumar Pisupati Member since 2015 74 posts
Optum
Posted: 1 year ago
Last activity: 1 year 10 months ago
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 Low-Code App Development Dev/Designer Studio
Moderation Team has archived post
Share this page LinkedIn