Support Article
MSOParseExcelFile activity does not parse uploaded Excel file
SA-42543
Summary
Error on parsing an uploaded Excel file using the out-of-the-box MSOParseExcelFile activity.
Error Messages
Unrecognized Excel template
Steps to Reproduce
- Create an Excel template and upload it as a binary file (use FilePath control).
- Download the binary file and populate it.
- Define an activity calling MSOParseExcelFile and pass the necessary parameters.
- Use the out-of-the-box FilePath control to upload the populated path.
- Run the Tracer.
Root Cause
The path of the file, FSFileName, sent to MSOParseExcelFile was incorrect.
Resolution
Perform the below local-change:
Set FSFileName from pxRequestor.pyFileUpload.
Published February 9, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.