Parsing .xls file

General
, ,
1

Currently pxParseExcelFile activity does not parse .xls file type. Below are the steps to achieve this requirement.

  1. Go to Pega Market place and search for ADK File parsing. Download and import into your application stack.
  1. Set the below local variables in the parsing activity.

Local.FileReference = pxRequestor.pyFileUpload

Local.NewFileReference = @String.whatComesBeforeFirst(Local.FileReference,‘.’)+“.xlsx”

  1. Use the function - @ConvertXLSToXLSX(Local.FileReference,Local.NewFileReference)

  2. Create an .xlsx file type template only while using the pxParseExcelFile activity.

2

To parse an .xls file in Pega when the standard activity fails, you must first import the ADK File Parsing utility from the Pega Marketplace. Once installed, configure your parsing activity by setting a local variable to reference the uploaded file and creating a second variable that renames the extension to .xlsx. You then invoke the @ConvertXLSToXLSX function to transform the legacy format into a compatible modern file. Finally, execute the pxParseExcelFile activity using an .xlsx template to successfully process the data. This conversion bridge ensures the system can read older Excel formats without custom Java code.