Question
Evonsys
IN
Last activity: 7 Nov 2025 16:22 EST
Parsing .xlsx with pxParseExcel "Parse failed for the uploaded file.Cannot find zip signature within the first 4096 bytes" Error
1) Used Constellation Application
2) Configured Attachment Control to upload a xlsx file
3) On the submission of the view in the Case Type rule triggered an Utility to read the attachment key to open the attachment and triggered pxCreateFile Activity which created a path under pxProcess system page
4) Created appropriate binary file by uploading the appropriate template file and and in the utility mentioned in step 3 after pxCreateFile triggered pxParseExcel Activity by passing the necessary paramters, When I traced the implementation receiving "Parse failed for the uploaded file.Cannot find zip signature within the first 4096 bytes error
Updated: 10 Apr 2025 6:51 EDT
Pegasystems Inc.
IN
jpmorgan chase
IN
@agarc , does the same approach work in virtual machine I have setup for practicing LSA course?, I followed the same steps, but there is error in logs that file not found.
HCA Healthcare
US
This error means Pega is not able to read the uploaded Excel file properly because it cannot detect the required ZIP format inside the file. This usually happens when the file is not uploaded or processed correctly. To fix this, make sure the file is uploaded using the Attachment control and saved as a proper file-type attachment. Then, instead of using pxCreateFile directly, first use pxGetAttachmentContent to get the correct file content. After that, pass this content to pxParseExcel with the right parameters like file name and binary template file. Ensure the binary file used as a template is correct and matches the structure of the uploaded Excel. Also, double-check that the file is not corrupted and was saved properly in Excel before uploading.
Hi @RaviKiranI7721, I have created an activity with the steps you mentioned in Constellation application 24.2v. After calling the pxCreateFile activity of Data-Artifact class, I am setting the file name parameter for pxParseExcelFile as the concatenation of pxProcess.pxServiceExportPath+ the file name along with the extension (pxAttachName from the Data-WorkAttach-File record). While calling the pxParseExcelFile, the xlsx template and the file name is passed. The excel data is successfully parsed and stored in the pagelist property mentioned in the binary template. Please find the screenshot of the custom activity as below.
Thank you!