Question
Infosys
IN
Last activity: 23 Jul 2019 9:57 EDT
Unable to read the Binary file while parsing an excel document in Pega
I have a requirement to upload an excel sheet and parse the data in pega. I have created a binary file and loaded the template also.Using the ootb activity "MSOGenerateExcelFile" I tried to parse the sheet.But i am getting the following error while running.
"(Code-Pega-List)Failed to open Rule-File-Binary with Application Name = excel, File Name = BulkLoadCase and File Type = xlsx"
Kindly help in resolving the issue
Attaching the screens for the activity also
Pegasystems Inc.
IN
Can you please share us the Binary File screenshot as well ?
Have you created the binary file like below ?
Pegasystems Inc.
IN
Use MSOParseExcelFile activity to read the content from the excel sheet. MsoGenerateExcelFile is used for generating excel sheet from clipboard data. Thanks.
Pegasystems Inc.
SG
Hi ,
I recently used this Activity successfuly and thought to share the details with the community , in case someone is still facing this issue.
Instead of calling MsoGenerateExcelFile directly , i created a copy ("Save as") and used on the calling activity . See below screen shot of both activities.
Copy(Save as) of MsoGenerateExcelFile:
Calling Activity:
