Excel - Unlock

** AVAILABLE SEPTEMBER / OCTOBER 2024 **

Overview

The 'Excel - Unlock' Power Automate action unlocks / removes protection from the Excel file provided aligned to the specified configuration.

The application replicates the capabilities of Excel's native protection features:

Input File Types

The following file types are supported:

• XLSX
• XLS

Credit Count

This action consumes 1 credit per operation.

Note, different Encodian actions can consume different number credits. Please always check the action specific documentation and read What is an Encodian Action for a full description of how credits are consumed.

Default Parameters

The default 'Excel - Unlock' flow action parameters are detailed below:

• File Content: A Base64 encoded representation of the Excel file to be processed
• Secure on Open Password: Optional - Set the password used to open the Microsoft Excel file
• Workbook Protection Password: Optional - Set the password used to remove protection from the Excel Workbook
• Worksheet Protection Password: Optional - Set the password used to remove protection from the specified Excel worksheets

Advanced Parameters

The advanced 'Excel - Unlock' flow action parameters are detailed below:

• Worksheet Names: A comma separated list of the names of the worksheets to remove protection from: Sales, Totals, Year to Date
• Worksheet Indexes: A comma separated list of indexes of the worksheets to remove protection from: 1,3,4
• Culture Name: This setting is used to set the culture for the workbook prior to conversion. Please refer to the Culture Names article for a list of supported cultures. 

Return Parameters

The 'Excel - Unlock' flow action returns the following data. 

Action Specific Return Values

• File Content - The processed file (Base64)

Standard Return Values

• OperationId - The unique ID assigned to this operation.
• HttpStatusCode - The HTTP Status code for the response.
• HttpStatusMessage - The HTTP Status message for the response.
• Errors - An array of error messages should an error occur.
• Operation Status - Indicates whether the operation has been completed, has been queued or has failed.