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.