cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to copy Excel document with locked sheets

Situation:

     My workflow is using Call Web Service for copyAs Excel file.

     Sheets/areas in this Excel document must be locked for specify person(autentification via domain).

     For example in sheet1 only can be used by personA, but in sheet2 only personB can change something.

 

Excel:

     I set in Excel document locked sheets(by password).

 

Nintex:

     In Nintex i have 3x Call Web Service(open session, copy document, close session).

 

Problem:

     How can i make Nintex/Excel when i have to use Excel with locked cells/sheets?

     First Call Web Service cannot open session for Excel document with locked sheets.

 

Thank you a lot for help.

Labels: (1)
0 Kudos
Reply
3 Replies
Not applicable

Re: How to copy Excel document with locked sheets

Hi Dawid Magdon​,

In a web service you can use Workflow constant for credentials.

You can create the Workflow Constant on Farm level as well.

The account you specify for the Workflow Constant should have permissions on both sheets so that it can execute all actions.

0 Kudos
Reply
Not applicable

Re: How to copy Excel document with locked sheets

I'm using my own Workflow Constant but still cannot open session with Excel document with locked sheets.

I have error, check image below.

blad1.PNG

blad2.PNG
Settings:

blad3.PNG

0 Kudos
Reply
Not applicable

Re: How to copy Excel document with locked sheets

Dawid Magdon,

 

Did you capture the whole error? The history only logs 255, thus you could e-mail it. If you already did, does it mention the protected sheets?

 

If you want to copy the Excel file, can you not just use copy to sharepoint?

 

0 Kudos
Reply