Question
Anthem Inc
US
Last activity: 10 Jan 2024 11:25 EST
Documentation on Parsing excel (.xlsx) file using file listener
Hi,
I have a requirement to read an excel file using file listener and load data to table. I didn't find any proper documentation for this. Verified multiple articles but none provided clear information on how to achieve this. Could someone help in finding out proper documentation on this.
Regards,
Bhanu.
***Edited by Moderator Rupashree to add Capability tags***
Updated: 10 Jan 2024 11:25 EST
Pegasystems Inc.
GB
@BhanukiranB In Pega 8.8, users can use the pxParseExcelFile activity to parse and load data from .xlsx format Excel files. However, it's important to note that pxParseExcelFile is designed to support Page List only and not complex forms that contain both Single Value property and Page List property.
Despite being deprecated, the MSOParseExcelFile activity is still functional and can be used if necessary.
you can find documentation here:
Best practices for processing files using the file listener
Service File form - Completing the Request tab
Activities for integrating cases with Excel documents
OOTB activity pxParseExcelFile and MSOPaseExcelFile.It works of .xlsx format b
@BhanukiranB In Pega 8.8, users can use the pxParseExcelFile activity to parse and load data from .xlsx format Excel files. However, it's important to note that pxParseExcelFile is designed to support Page List only and not complex forms that contain both Single Value property and Page List property.
Despite being deprecated, the MSOParseExcelFile activity is still functional and can be used if necessary.
you can find documentation here:
Best practices for processing files using the file listener
Service File form - Completing the Request tab
Activities for integrating cases with Excel documents
OOTB activity pxParseExcelFile and MSOPaseExcelFile.It works of .xlsx format b
How to use MSOParseExcelFile and MSOGenerateExcelFile
Please hit 'Accept Solution' if this answers your question.