Unprotect Excel FIles using power automate

Question

I have created Template excel file for my colleagues to upload their rosters each month, they do this by uploading the roster to Microsoft forms, then I manage to rename the excel sheets and move them to a new folder using power automate.

While the process is good and convenient, the Excel Template is protected with a password, and each time I am working with these large files I need to manually opens each one and then enter the password so I can work on them.

I am just asking if there is a way in power automate unprotected the sheet before move them to the final folder automatically since I have the password.

Searching google on this, and looking for post, but there was no answer near my question.

Skin · Accepted Answer · 2023-04-14 12:36:43Z

1

Yep, use Office Scripts.

Never used Office Scripts before? If so, check out these links.

https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel

https://support.microsoft.com/en-us/office/introduction-to-office-scripts-in-excel-9fbe283d-adb8-4f13-a75b-a81c6baf163a

This is a basic script which shows how to unprotect at the workbook level and the worksheet level respectively.

function main(workbook: ExcelScript.Workbook, password: string) {
    workbook.getProtection().unprotect(password);

    workbook.getWorksheets().forEach(sheet => {
        sheet.getProtection().unprotect(password);
    });
}

You're then able to call that script over any book from PowerAutomate using the Run script operation from the Excel online (business or OneDrive).

answered Apr 14, 2023 at 12:36

Skin

11.7k3 gold badges16 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Yi Lu · Accepted Answer · 2023-05-19 20:00:54Z

0

after run the script for protected. There is nothing change in the workbook. workbook still can be open

answered May 19, 2023 at 20:00

Yi Lu

1

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Unprotect Excel FIles using power automate

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related