Parse Excel File via File listener
I have requirement to read the excel file via File listener. Can anybody please suggest the approach?
When using the path from LogServiceFile.pyPathName I am getting java.io.FileNotFoundException.
Updated: 28 Oct 2022 2:07 EDT
Pegasystems Inc.
IN
@Asutosh Hi can you please confirm if it is an excel file or csv?
If it is excel can you please check the below links and see if it is useful?
https://support.pega.com/question/parsing-excel-usinf-file-listener
https://support.pega.com/question/parse-excel-file-using-file-listener
https://support.pega.com/question/parse-excel-file-using-file-listener-0
https://support.pega.com/question/file-path-problems-parsing-excel-file-using-file-listener
https://support.pega.com/discussion/parsing-excel-file
https://support.pega.com/question/parse-excel-file-error
Please let us know if you still face issue
Datacom
NZ
@SrinidhiM it is an excel file. I had gone through the above mentioned links. One of them "https://support.pega.com/question/parse-excel-file-using-file-listener-0" says that we have to modify the activity "MSOParseExcelFile". this activity is deprecated and we have an activity called "pxParseExcelFile" instead of it but it is a final rule.
Pegasystems Inc.
IN
@Asutosh Hi Can you check the below links this might be helpful use pxParseExcelFile instead of MSOparseExcelFile
https://support.pega.com/discussion/upload-data-using-file-listener-combines-msoparseexcelfile
Datacom
NZ
@SrinidhiM The problem here is "pxParseExcelFile" is a final activity and the article says to modify the Java step present inside the activity. I want to know if there is any other approach