Question
Tata Consultancy Services
US
Last activity: 19 Oct 2018 5:27 EDT
Parsing the uploaded excel file in xlsx format using MSOParseExcelFile activity throws error
Hi All,
Process followed are as below:
1) Created rule-file-binary ( with key values :excel, ProductTemplate, xlsx) and uploaded template with property reference.
2)Called the rule MSOParseExcelFile and passed the parameters passed are as below:
"Sheet1"
"excel!ProductTemplate!xlsx"
3) Tried to pass the excel file with data and received the below error. : '**** The uploaded file template could not be recognized. Please upload a valid file. Refer to template ProductTemplate for details'. I am using V6.1 and the file path generated is file://web:/StaticContent/global/ServiceExport/Sheet1.xlsx
Synechron
IN
do check the file you are uploading is in exact format as the template. Row x Column of each field should match in Template and Actual file.
if you have already done this. you can refer to a post - http://vamshikassety.blogspot.in/2015/08/parse-excel-file.html
hope it helps.
Telecom Italia S.P.A.
IT
Hi,
With Pega 7.2.1 I have solved this problem using this path:
- LogServiceFile.pyOriginalDirectory + "/work_" + "File Listener Name"+ "/" + LogServiceFile.pyWorkFileName
Thanks,
V.
CollabPartnerz
IN
Hi,
Below link might help you.
https://collaborate.pega.com/question/issue-while-invoking-msoparseexcel-activity-parsing-xlsx-file