Posted: 8 Nov 2018 13:31 EST Last activity: 15 Nov 2018 2:46 EST
What is the best approach to read & parse data from a xls file using FileListener?
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.
Ravi Kumar Pisupati.
***Edited by Moderator Marissa to update platform capability tags****