Skip to Content
0

SAP PCO Excel Read Only Mode

Dec 21, 2016 at 10:34 AM

76

avatar image
Former Member

Hello Experts,

I am in a scenario to read a excel file from shared location. I have created a OLE DB connector in PCo. Now I come across 2 scenarios:

  1. Password protected file: If the file is password protected, I gave the password of file in Connection tab in specified username and password section. Still Test connection option throws me a error.
  2. If file is already opened by another user by connection fails even when I access it in Read mode. It throws error as "it is opened exclusively by another user or you do not have permissions to view or write its data". In this scenario, can we force file to open in Read Only mode just as I would do when I open it manually?
  3. If I remove the password and close the file, then data is properly browsed without any issue.

Please provide your inputs.

Regards,

Minakshi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers