Question

Parsing Excel Usinf File Listener

We have a requirement where File Listener should parse the excel file. The excel file is present in a specific folder and having data only. How to achieve this one?

**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.

Correct Answer
November 15, 2017 - 2:12pm

The issue was resolved .we got the path from LogServiceFile page of the File Listener.Thank you again.

 

 

 

Comments

Keep up to date on this post and subscribe to comments

November 10, 2017 - 8:14am

Hi Pooja,

Had you gone through this discussion which has some useful information about parsing excel file using file listener. Hope it might help you.

Regards

Mahesh

November 14, 2017 - 7:26am
Response to Mahesh Midthuru

Thanks for the link.I  am able to achieve it by using MSOParseExcelFile as stand alone.What I am trying is to parse the Excel file using MSOParseExcelFile using a File listener.I am giving service Export path in pxRequsetor.pyFileName.But it seems File Listner is not getting the File or somewhere error is there. Please find the screenshots.

November 14, 2017 - 8:21am
Response to poojad99

@Pooja, i don't see any attachments being shared.

November 15, 2017 - 2:12pm
Response to Mahesh Midthuru

The issue was resolved .we got the path from LogServiceFile page of the File Listener.Thank you again.

 

 

 

December 27, 2017 - 3:35am
Response to poojad99

Hi Pooja,

We are also having same requirement but unable to get path using file listner from LogServiceFile. we are getting java.io.FileNotFoundException.

Could you please share configuration details you have done for your requirement.