Excel - Add Image Header or Footer

** AVAILABLE SEPTEMBER / OCTOBER 2024 **

Overview

The 'Excel - Add Image Header or Footer' Power Automate action adds the image provided into the specified Header or Footer location(s) of the Excel file provided.

NOTE: Both Headers and Footers are not visible until the file is printed or viewed via print preview.

Input File Types

The following file types are supported:

• XLSX
• XLS

The following image file formats are supported:

• BMP
• JPG
• GIF
• PNG

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 - Add Image Header or Footer' flow action parameters are detailed below:

• File Content: A Base64 encoded representation of the Excel file to be processed
• Image File Content: The file content of the image to insert
• Position: The position to add the image to within the Microsoft Excel file provided

Please refer to the Obtaining the 'File Contents' Parameter article for guidance on how to obtain the 'File Content' parameter ready to provide to an Encodian flow action. 

Advanced Parameters

The advanced 'Excel - Add Image Header or Footer' flow action parameters are detailed below:

• Worksheet Names: A comma separated list of the names of the worksheets to remove the watermark from: Sales, Totals, Year to Date
• Worksheet Indexes: A comma separated list of indexes of the worksheets to remove the watermark from: 1,3,4
• Top Margin: Set the top margin value (cm) The default value is set to 1.9
• Bottom Margin: Set the bottom margin value (cm) The default value is set to 1.9
• Right Margin: Set the right margin value (cm) The default value is set to 1.9
• Left Margin: Set the left margin value (cm) The default value is set to 1.9
• 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 - Add Image Header or Footer' 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.