Venkateshwar Thipparthi (VenkateshwarT)
Incessant Technologies

Incessant Technologies
VenkateshwarT Member since 2012 4 posts
Incessant Technologies
Posted: February 14, 2017
Last activity: October 16, 2018
Posted: 14 Feb 2017 4:01 EST
Last activity: 16 Oct 2018 12:03 EDT

Parse Excel File - Using File Listener

Hi Team,

I am trying to parse excel file with multiple sheets with the activity 'MSOParseExcelFile'. I have tried this according to the suggested approach on a blog ''. Using this approach I was successful by creating the binary file template with necessary page list properties and tested by uploading the file using 'MSOFileTransferButtons' control where the 'pxRequestor.pyFileUpload' property is passed on to the 'MSOParseExcelFile' as location parameter. When the file was uploaded the sheets were loaded to respective page list properties on clipboard and was working fine.

However, my target is to use this approach in a file listener where when I pass the 'source location' along with file name to 'MSOParseExcelFile' activity which is called from Service File activity, it throws a 'file not found exception' at the specified location. I have given the same path as in the 'source location' given in the file listener and verified the same location through the 'Log-Service-File' entry.

All I need to do is to pass 2 parameters to 'MSOParseExcelFile' - 1st is the template key and 2nd is the file location. The file location is failing and causing issue.

However, the Excel file was getting parsed when the 'ServiceExport' path was passed as the file location.

Any help to resolve this would be appreciated.


***Updated by Moderator: Marissa to update categories***

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Data Integration Support Case Exists
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.