Support Article

Downloading Excel Template option is not working

SA-33026

Summary



When user downloads an Excel template from a binary file (Rule-File-Binary) and after populating the excel sheet with required data, an error is thrown while uploading and parsing the excel file within Pega.


Error Messages



Error Messages:
Errors: ** The uploaded file template could not be recognized. Please upload a valid file. Refer to template ExcelFileTemplate for details.


Steps to Reproduce


  1. Create a Binary File and upload an xlsx file format template.
  2. Download the Empty Template in the Work Flow.
  3. Update the data in the Excel file.
  4. Try to upload the updated excel file using FilePath Control. Error Message appears on processing of the assignment.


Root Cause



An issue in the custom application code or rules: Pega removes any pre and post white spaces of the column name in template file.

Resolution



Perform the following local-change:

Update template column names to ensure there is no white space appended or pre-pended.

Published January 30, 2017 - Updated February 13, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.