Excel - Unlock

** AVAILABLE JULY 24 > AUGUST 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

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.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk