Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Jayashree Purushothaman (JAYASHREE-1)
Tcs

Tcs
US
JAYASHREE-1 Member since 2013 3 posts
Tcs
Posted: Sep 16, 2016
Last activity: Sep 21, 2016
Posted: 16 Sep 2016 12:31 EDT
Last activity: 21 Sep 2016 0:35 EDT
Closed

Email Listener- How to parse an excel attachment in the email?

Hi,

I will be receiving an excel file as an arrachment in an email. I will have to read the contents from the excel file and update it on the case. I am using Email listener and looping through pyAttachmentPage.pyAttachNames and using MSOParseExcelFile activity to read the contents of the excel. I am receiving an error stating that the uplodaded file doesn't match the template. But the file which i am using was downloaded from the template and I just added the values to it.

Please let me know on how to read the contents.

***Updated by Moderator: Marissa. Removed user added FAQ group tag. Apologies for confusion, shouldn't have been an end-user option***

To see attachments, please log in.
Data Integration

  • Prabakaran Soundararajan
Posted: 8 years ago
Posted: 16 Sep 2016 22:46 EDT
Evita Lobo (loboe) Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Jayashree,

Thank you for posting your question.

Could you specify the file extension of the excel file uploaded? Since MSOParseExcelFile is used to parse the files with extension .xlsx files only. It is the limitation of this activity.

Thank you.

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice