Question
Infosys Ltd
CA
Last activity: 26 May 2022 9:30 EDT
Email Listener- How to parse an excel attachment in the email
We have a requirement to parse the records present in an excel which comes as the attachment in an email.
For each record in the excel, we need to process the business logic as per the requirement.
Tried using MSOParseExcelFile activity but the got an error in the tracer that the uploaded file doesn't match the template(pzUnrecognizedFileTemplate). I believe its due to fact that only the ServiceExport path needs to be passed to the activity.
Is there a way to store the attachment in serviceexport directory path from email and get to know the location address.
Need assistance in knowing other methods on how the excel records can be parsed.
***Edited by Moderator: Lochan to update platform capability tags***