Question

7
Replies
4304
Views
VenkateshwarT Member since 2012 4 posts
Incessant Technologies
Posted: 3 years ago
Last activity: 2 years 6 months ago
Closed
Solved

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 'http://vamshikassety.blogspot.in/2015/08/parse-excel-file.html'. 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.

Thanks
Venkat

***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 SR Exists
Moderation Team has archived post
Share this page LinkedIn