Excel - Add Text Watermark

** AVAILABLE AUGUST 2024 **

Overview

The 'Excel - Add Text Watermark' Power Automate action adds a text watermark to the Excel file provided aligned to the specified configuration.

Input File Types

The following file types are supported:

  • XLSX
  • XLS

Default Parameters

The default 'Excel - Add Text Watermark' flow action parameters are detailed below:

  • File Content: A Base64 encoded representation of the Excel file to be processed
  • Text: The text to embed as a watermark within the Microsoft Excel file
  • Row Position: Set the numeric row that the watermark should be inserted from
  • Column Position: Set the numeric column that the watermark should be inserted from
  • Container Height: Set the height of the container which contains the watermark text (in pixels)
  • Container Width: Set the width of the container which contains the watermark text (in pixels)

The text of the watermark will be displayed on a single line, whereby the font size is governed by the dimensions of the container. 

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 Text Watermark' flow action parameters are detailed below:

  • Font: Set the font type applied to the text watermark, the default font is set to Calibri
  • Text Colour: Set the HTML colour applied to the text watermark, the default colour is set to #808080 (Grey)
  • Italic: Set whether to apply the 'Italic' format to the text
  • Bold: Set whether to apply the 'Bold' format to the text
  • Opacity: The opacity of the text watermark, valid values range from 0 to 1 (Hidden), the default value is 0.7
  • Rotation Angle: Set the rotation angle of the watermark in degrees
  • Worksheet Names: A comma separated list of the names of the worksheets to add the watermark to: Sales, Totals, Year to Date
  • Worksheet Indexes: A comma separated list of indexes of the worksheets to add the watermark to: 1,3,4
  • Watermark ID: Override and manually set an identifier for the applied watermark
  • 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 Text Watermark' flow action returns the following data. 

Action Specific Return Values

  • File Content - The processed file (Base64)
  • Watermark ID - The watermark ID

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