Excel - Secure

Overview

The 'Excel - Secure' Power Automate action secures 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

Usage Notes

If you have selected Workbook Protection Type the action allows you to chose Structure, Windows, All or None. Please be aware that if you choose All or Windows you will not be able to open the file in the online version of Excel; it will however open as expected in the desktop version. This is due to an Excel online limitation where the online version does not have all the features that the desktop version does and not a fault in the file. 

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 - Secure' 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 Type: Set the protection type to apply to the Excel Workbook
• Workbook Protection Password: Optional - Set the password used to protect the Excel Workbook
• Worksheet Protection Type: Set the protection type to apply to the Excel worksheets
• Worksheet Protection Password: Optional - Set the password used to protect the specified Excel worksheets (All by default)

Advanced Parameters

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

• Worksheet Names: A comma separated list of the names of the worksheets to protect: Sales, Totals, Year to Date
  
• Worksheet Indexes: A comma separated list of indexes of the worksheets to protect: 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 - Secure' 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.