Question
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****
Hi,
Had you gone through below discussion which has some useful information about parsing excel file using file listener. Hope it might help you.
https://community1.pega.com/community/pega-support/question/parse-excel-file-using-file-listener
Thank you