Add Image Header Footer to Excel in Power Automate

PDF4me Add Image Header Footer to Excel action enables adding customizable image headers and footers to Excel documents in Power Automate with comprehensive positioning and formatting control. This powerful feature supports company logos, watermark images, branding elements, and visual stamps with full control over image placement (header/footer), position alignment (left, center, right), worksheet targeting (specific sheets or all sheets), and page margins, perfect for corporate branding and professional document presentation across Microsoft 365 workflows.

Authenticating Your API Request

To access the PDF4me Web API through Power Automate, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Power Automate flows and PDF4me's powerful Excel formatting services.

Get your API Key

Add Image Header Footer to Excel Power Automate

Key Features

Simple Image Input: Use image file content from any source in your flow
Header or Footer Placement: Choose whether to place images in document header or footer sections
Position Control: Align images left, center, or right within header/footer area
Worksheet Targeting: Apply images to specific worksheets by name or index, or all worksheets
Margin Customization: Configure top, bottom, left, and right page margins in centimeters

Parameters

Complete list of parameters for the Add Image Header Footer to Excel action. Configure these parameters to control image formatting.

Important: Parameters marked with an asterisk (***) are required.

Parameter	Type	Description	Example
File Content***	Base64	Source Excel File Content • Map Excel file from previous action output • Supports Excel files from SharePoint, OneDrive, email attachments • Can be dynamically retrieved from flow variables • Must be valid Excel document (.xlsx, .xls formats)	`[File Content from Get File]`
File Name***	String	Excel Document Name • Specify Excel file name with extension (.xlsx, .xls) • Used for processing and output file naming • Must include proper file extension • Supports dynamic naming from flow variables	`data.xlsx`
Image Content***	Base64	Source Image File Content • Map image file from previous action output • Supports image files from SharePoint, OneDrive, email attachments • Can be dynamically retrieved from flow variables • Must be valid image file (PNG, JPG, JPEG, GIF formats)	`[File Content from Get File]`
Is Header	Boolean	Placement Selection • True - Add image to document header • False - Add image to document footer • Default: true • Controls vertical placement	`true`
Position	String	Horizontal Alignment • Left - Align image to left edge • Center - Center image horizontally • Right - Align image to right edge • Default: "Center" • Case-insensitive	`Center`
Worksheet Names	Array (string[])	Target Worksheet Names • Array of worksheet names to apply image to • Example: ["Sheet1", "Summary", "Report"] • If both WorksheetNames and WorksheetIndexes are empty, applies to all worksheets • Worksheet names must match exactly	`["Sheet1", "Report"]`
Worksheet Indexes	Array (int[])	Target Worksheet Indexes • Array of worksheet indexes (1-based numbering) • Example: [1, 3, 5] for first, third, and fifth sheets • If both WorksheetNames and WorksheetIndexes are empty, applies to all worksheets • Index starts at 1, not 0	`[1, 2]`
Top Margin	Number (double)	Top Page Margin • Top page margin in centimeters • Default: 1.9 cm • Controls spacing from top edge • Affects header placement	`1.9`
Bottom Margin	Number (double)	Bottom Page Margin • Bottom page margin in centimeters • Default: 1.9 cm • Controls spacing from bottom edge • Affects footer placement	`1.9`
Left Margin	Number (double)	Left Page Margin • Left page margin in centimeters • Default: 1.9 cm • Controls spacing from left edge • Affects overall page layout	`1.9`
Right Margin	Number (double)	Right Page Margin • Right page margin in centimeters • Default: 1.9 cm • Controls spacing from right edge • Affects overall page layout	`1.9`

Note: FileContent, FileName, and ImageContent are always required. If both WorksheetNames and WorksheetIndexes are empty or null, the image will be applied to all worksheets in the Excel file.

Output

The PDF4me Add Image Header Footer to Excel action returns comprehensive output data for seamless Power Automate flow integration:

Table
JSON
Flow Integration

Table View

Response data in a structured table format:

Parameter	Type	Description
document	Base64	Excel document with image header/footer applied
Success	Boolean	true if operation successful, false if failed
Error Message	String	Error description (null if successful)
Errors	Array	List of detailed error information (empty array if successful)

JSON Response Format

The raw JSON response from the action:

{
  "document": "[Base64 Excel Content with Image Header/Footer]",
  "Success": true,
  "ErrorMessage": null,
  "Errors": []
}

Error Response Example:

{
  "document": null,
  "Success": false,
  "ErrorMessage": "Invalid image format",
  "Errors": [
    {
      "Code": "IMAGE_ERROR",
      "Message": "The provided image format is not supported"
    }
  ]
}

Common Error Messages

Understanding and troubleshooting errors helps ensure smooth Excel image header/footer insertion workflows:

Error Message	Cause	Solution
"Request is empty"	Request object is null	Provide valid request object
"Document is empty"	Document object is null	Provide valid Excel document
"Image content is empty"	ImageContent is null	Provide valid image content from file
"Invalid worksheet selection"	Worksheet names/indexes don't exist or are out of range	Use existing worksheet names or valid indexes (1-based)
"Available worksheets in workbook (X total)"	Informational message shown when worksheet selection validation fails	Review worksheet names/indexes and use valid values from the X available worksheets

Workflow Examples

The PDF4me Add Image Header Footer to Excel action in Power Automate provides comprehensive workflow templates designed for real-world business scenarios:

Corporate Branding
Confidential Watermark
Client Deliverables
Financial Reports

Automated Corporate Logo Header Workflow

Transform your document branding with automated logo insertion in Excel reports:

Complete Workflow Steps:

Trigger: Scheduled trigger - weekly report generation every Monday at 8 AM
Get Excel Report: Retrieve weekly performance report from SharePoint
Get Logo Image: Fetch company logo from SharePoint image library
Add Logo Header: Insert logo image in header with center alignment
Set Margins: Apply standard 1.9 cm margins for professional appearance
Apply to All Sheets: Target all worksheets in the workbook
Email Distribution: Send branded report to management team
Archive: Store branded report in corporate reports library

Business Benefits:

Brands 52 weekly reports annually with corporate logo automatically
Ensures consistent branding across all Excel documents
Eliminates manual logo insertion saving 10 minutes per report
Enhances professional image with automated branding

Create Flow

Industry Use Cases & Applications

Finance & Accounting Use Cases

Financial Statements: Add company logo headers to quarterly reports
Budget Reports: Insert department logos on budget worksheets
Audit Documents: Apply audit firm logo watermarks in footers
Expense Reports: Add corporate logo headers for expense submissions

Get Help

PDF4me Connect Get your API Key Power Automate Documentation

Authenticating Your API Request​

Key Features​

Parameters​

Output​

Common Error Messages​

Workflow Examples​

Industry Use Cases & Applications​

Get Help​