Share via

PDF4me Excel (Preview)

Enhance your workflows with the powerful capabilities of the PDF4me Excel Connector. Comprehensive features for creating and manipulating Excel and CSV file formats. Seamlessly integrate advanced Microsoft Excel, Spreadsheet features, and more to drive better efficiency and intelligence across your processes.

This connector is available in the following products and regions:

Service Class Regions
Copilot Studio Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name PDF4me Support
URL https://dev.pdf4me.com/support/
Email support@pdf4me.com
Connector Metadata
Publisher Ynoox GmbH
Website https://dev.pdf4me.com/
Privacy policy https://dev.pdf4me.com/privacy-policy/
Categories AI;Website

Title: PDF4me Excel

Description: Enhance your workflows with the powerful capabilities of the PDF4me Excel Connector. Comprehensive features for creating and manipulating Excel and CSV file formats. Seamlessly integrate advanced Microsoft Excel, Spreadsheet features, and more to drive better efficiency and intelligence across your processes.

Publisher: Ynoox GmbH

Prerequisites : You need a trial or an active/valid subscription in order to try our Excel features.

Supported Operations

Operation 1 : Excel - Add Text Header Footer","Add customizable text headers and footers to Excel worksheets with full formatting control https://docs.pdf4me.com/integrations/power-automate/excel/add-text-header-footer/,

Operation 2 : Excel - Add Image Header Footer","Add image-based headers and footers to Excel worksheets with precise positioning and margin control https://docs.pdf4me.com/integrations/power-automate/excel/add-image-header-footer/,

Operation 3 : Excel - Remove Header Footer","Remove specific header and footer elements from Excel worksheets https://docs.pdf4me.com/integrations/power-automate/excel/remove-header-footer/,

Operation 4 : Excel - Add Rows","Insert new rows into Excel worksheets using JSON data with automatic data type conversion and formatting https://docs.pdf4me.com/integrations/power-automate/excel/actions/add-rows/,

Operation 5 : Excel - Update Rows","Update existing rows in Excel worksheets with JSON data and precise cell targeting https://docs.pdf4me.com/integrations/power-automate/excel/actions/update-rows/,

Operation 6 : Excel - Delete Rows","Delete specific rows from Excel worksheets using row ranges https://docs.pdf4me.com/integrations/power-automate/excel/delete-rows/,

Operation 7 : Excel - Extract Rows","Extract specific rows from Excel worksheets and convert to JSON format with advanced filtering options https://docs.pdf4me.com/integrations/power-automate/excel/extract-rows/,

Operation 8 : Excel - Extract Worksheets","Extract specific worksheets from Excel workbooks and return as JSON data https://docs.pdf4me.com/integrations/power-automate/excel/extract-worksheets/,

Operation 9 : Excel - Delete Worksheets","Delete specific worksheets from Excel workbooks https://docs.pdf4me.com/integrations/power-automate/excel/delete-worksheets/,

Operation 10 : Excel - Merge Files","Merge multiple Excel files into a single workbook with support for various output formats https://docs.pdf4me.com/integrations/power-automate/excel/merge-files/,

Operation 11 : Excel - Merge Rows","Merge rows across multiple worksheets using key columns for data consolidation https://docs.pdf4me.com/integrations/power-automate/excel/merge-rows/,

Operation 12 : Excel - Add Text Watermark","Add customizable text watermarks to Excel worksheets with advanced positioning and styling options https://docs.pdf4me.com/integrations/power-automate/excel/add-watermark/,

Operation 13 : Excel - Remove Watermark","Remove watermarks from Excel worksheets by ID or from all worksheets https://docs.pdf4me.com/integrations/power-automate/excel/remove-watermark/,

Operation 14 : Excel - Replace Text","Find and replace text in Excel worksheets with advanced pattern matching and formatting options https://docs.pdf4me.com/integrations/power-automate/excel/replace-text/,

Operation 15 : Excel - Secure File","Add password protection and security restrictions to Excel files https://docs.pdf4me.com/integrations/power-automate/excel/secure-excel/,

Operation 16 : Excel - Unlock File","Remove password protection and security restrictions from Excel files https://docs.pdf4me.com/integrations/power-automate/excel/unlock-excel/,

Operation 17 : CSV - Parse to JSON","Parse CSV files and convert to Excel format with customizable delimiters and formatting https://docs.pdf4me.com/integrations/power-automate/excel/parse-csv/,

Obtaining Credentials : To use this integration, you need to have an account on the PDF4me Developer Portal. Follow steps below to get your Subscription Key.

How to get PDF4me Subscription Key

  • Register in PDF4me Developer Portal and start a Free Trial
  • Go to Api Keys tab in the Developer Portal.
  • Select an application or Create a new application.
  • You will find a Primary Key and Secondary Key listed under the application. Click on Copy Key button beside the Primary Key for Power Automate text and paste it to Power Automate PDF4me connection

Getting Started : You can integrate PDF4me connector with Flow in easy steps. To know about the integration & more, visit our documentation page: PDF4me : Getting Started

Known Issues and Limitations : None

Deployment Instructions : It is very simple to deploy as any other costom connector.

You're now ready to start using this Excel integration.

Creating a connection

The connector supports the following authentication types:
Default Parameters for creating connection. All regions Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name Type Description Required
api_key securestring The api_key for this api True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

CSV - Parse to JSON

Parse CSV files and convert to Excel format with customizable delimiters and formatting - https://docs.pdf4me.com/integrations/power-automate/excel/excel/parse-csv
Excel - Add Image Header Footer

Add image-based headers and footers to Excel worksheets with precise positioning and margin control - https://docs.pdf4me.com/integrations/power-automate/excel/add-image-header-footer
Excel - Add Rows

Insert new rows into Excel worksheets using JSON data with automatic data type conversion and formatting - https://docs.pdf4me.com/integrations/power-automate/excel/excel/add-rows
Excel - Add Text Header Footer

Add customizable text headers and footers to Excel worksheets with full formatting control - https://docs.pdf4me.com/integrations/power-automate/excel/add-text-header-footer
Excel - Add Text Watermark

Add customizable text watermarks to Excel worksheets with advanced positioning and styling options - https://docs.pdf4me.com/integrations/power-automate/excel/add-watermark
Excel - Delete Rows

Delete specific rows from Excel worksheets using row ranges - https://docs.pdf4me.com/integrations/power-automate/excel/delete-rows
Excel - Delete Worksheets

Delete specific worksheets from Excel workbooks - https://docs.pdf4me.com/integrations/power-automate/excel/delete-worksheets
Excel - Extract Rows

Extract specific rows from Excel worksheets and convert to JSON format with advanced filtering options - https://docs.pdf4me.com/integrations/power-automate/excel/extract-rows
Excel - Extract Worksheets

Extract specific worksheets from Excel workbooks and return as JSON data - https://docs.pdf4me.com/integrations/power-automate/excel/extract-worksheets
Excel - Merge Files

Merge multiple Excel files into a single workbook with support for various output formats - https://docs.pdf4me.com/integrations/power-automate/excel/merge-files
Excel - Merge Rows

Merge rows across multiple worksheets using key columns for data consolidation - https://docs.pdf4me.com/integrations/power-automate/excel/merge-rows
Excel - Remove Header Footer

Remove specific header and footer elements from Excel worksheets - https://docs.pdf4me.com/integrations/power-automate/excel/remove-header-footer
Excel - Remove Watermark

Remove watermarks from Excel worksheets by ID or from all worksheets - https://docs.pdf4me.com/integrations/power-automate/excel/remove-watermark
Excel - Replace Text

Find and replace text in Excel worksheets with advanced pattern matching and formatting options - https://docs.pdf4me.com/integrations/power-automate/excel/replace-text
Excel - Secure File

Add password protection and security restrictions to Excel files - https://docs.pdf4me.com/integrations/power-automate/excel/secure-excel
Excel - Unlock File

Remove password protection and security restrictions from Excel files - https://docs.pdf4me.com/integrations/power-automate/excel/unlock-excel
Excel - Update Rows

Update existing rows in Excel worksheets with JSON data and precise cell targeting - https://docs.pdf4me.com/integrations/power-automate/excel/update-rows

CSV - Parse to JSON

Operation ID:
ParseCsv

Parse CSV files and convert to Excel format with customizable delimiters and formatting - https://docs.pdf4me.com/integrations/power-automate/excel/excel/parse-csv

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
CSV Delimiter
 Delimiter string

Character used to separate values in the CSV
Column Headers
 ColumnHeaders string

Custom column headers (comma-separated)
Skip First Line
 SkipFirstLine boolean

Skip the first line when parsing
Culture Name
 CultureName string

Culture name for data parsing

Returns

Body
CsvParseRes

Excel - Add Image Header Footer

Operation ID:
AddImageHeaderFooter

Add image-based headers and footers to Excel worksheets with precise positioning and margin control - https://docs.pdf4me.com/integrations/power-automate/excel/add-image-header-footer

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
Image Content
 imageContent byte

The image file content as base64-encoded string
Image Position
 Position string

Position of the image in the header footer
IsHeader
 IsHeader boolean

Whether to add to header (true) or footer (false)
Target Worksheets - By Name
 WorksheetNames array of string

List of worksheet names to apply the image to (leave empty for all)
Target Worksheets - By Index
 WorksheetIndexes array of integer

List of worksheet indexes (1-based) to apply the image to (leave empty for all)
Top Margin (cm)
 TopMargin double

Top margin value in centimeters
Bottom Margin (cm)
 BottomMargin double

Bottom margin value in centimeters
Left Margin (cm)
 LeftMargin double

Left margin value in centimeters
Right Margin (cm)
 RightMargin double

Right margin value in centimeters
Culture & Language Settings
 CultureName string

Culture name for formatting (e.g., en-US, fr-FR, de-DE)

Returns

Body
AddImageHeaderFooterRes

Excel - Add Rows

Operation ID:
AddRows

Insert new rows into Excel worksheets using JSON data with automatic data type conversion and formatting - https://docs.pdf4me.com/integrations/power-automate/excel/excel/add-rows

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
JSON Row Data
 JsonInput string

Base64-encoded JSON data containing the rows to add to the Excel file. The JSON should be an array of objects where each object represents a row. Example JSON before Base64 encoding: [ {"Column1": "Value1", "Column2": "Value2"}, {"Column1": "Value3", "Column2": "Value4"} ]
Worksheet Name
 WorksheetName string

Name of the worksheet to add rows to
Insert From Row
 InsertFromRow integer

Row number where to start inserting data (1-based)
Insert From Column
 InsertFromColumn integer

Column number where to start inserting data (1-based)
Target Excel Table
 TableName string

Name of Excel table to add rows to (if applicable)
Excel Row Number
 ExcelRowNumber integer

Integer containing Excel Row Number If Table Name Is Given.
Convert Numeric And Date
 ConvertNumericAndDate boolean

Automatically convert numeric and date values to proper Excel data types
Date Format Pattern
 DateFormat string

Format pattern for date values (e.g., yyyy-MM-dd, dd/MM/yyyy)
Numeric Format Pattern
 NumericFormat string

Format pattern for numeric values (e.g., N2, C, P)
️ Skip JSON Property Names
 IgnoreAttributeTitles boolean

Skip JSON property names when inserting data
Skip Null Values
 IgnoreNullValues boolean

Skip null values from JSON data
Culture & Language Settings
 CultureName string

Culture name for data formatting (e.g., en-US, fr-FR, de-DE)

Returns

Body
AddRowsRes

Excel - Add Text Header Footer

Operation ID:
AddTextHeaderFooter

Add customizable text headers and footers to Excel worksheets with full formatting control - https://docs.pdf4me.com/integrations/power-automate/excel/add-text-header-footer

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
Header Left Text
 HeaderLeft string

Text content for the left section of the header
Header Center Text
 HeaderCenter string

Text content for the center section of the header
Header Right Text
 HeaderRight string

Text content for the right section of the header
Footer Left Text
 FooterLeft string

Text content for the left section of the footer
Footer Center Text
 FooterCenter string

Text content for the center section of the footer
Footer Right Text
 FooterRight string

Text content for the right section of the footer
Header Left - Color
 HeaderLeftColor string

Color for the left header text (hex code or color name)
Header Left - Font Size
 HeaderLeftFontSize integer

Font size for the left header text
Header Center - Color
 HeaderCenterColor string

Color for the center header text (hex code or color name)
Header Center - Font Size
 HeaderCenterFontSize integer

Font size for the center header text
Header Right - Color
 HeaderRightColor string

Color for the right header text (hex code or color name)
Header Right - Font Size
 HeaderRightFontSize integer

Font size for the right header text
Footer Left - Color
 FooterLeftColor string

Color for the left footer text (hex code or color name)
Footer Left - Font Size
 FooterLeftFontSize integer

Font size for the left footer text
Footer Center - Color
 FooterCenterColor string

Color for the center footer text (hex code or color name)
Footer Center - Font Size
 FooterCenterFontSize integer

Font size for the center footer text
Footer Right - Color
 FooterRightColor string

Color for the right footer text (hex code or color name)
Footer Right - Font Size
 FooterRightFontSize integer

Font size for the right footer text
Target Worksheets - By Name
 WorksheetNames string

Comma-separated list of worksheet names to apply headers/footers to (leave empty for all)
Target Worksheets - By Index
 WorksheetIndexes string

Comma-separated list of worksheet indexes (1-based) to apply headers/footers to (leave empty for all)
Culture & Language Settings
 CultureName string

Culture name for formatting (e.g., en-US, fr-FR, de-DE)

Returns

Body
AddTextHeaderFooterRes

Excel - Add Text Watermark

Operation ID:
AddWatermark

Add customizable text watermarks to Excel worksheets with advanced positioning and styling options - https://docs.pdf4me.com/integrations/power-automate/excel/add-watermark

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
Watermark Text
 WatermarkText string

Text content for the watermark
Font Family
 FontFamily string

Font family for the watermark text
Text Size
 TextSize integer

Text size (1=Small, 2=Medium, 3=Large, 4=Extra Large)
Bold Text
 IsBold boolean

Make watermark text bold
Italic Text
 IsItalic boolean

Make watermark text italic
Text Color
 TextColor string

Color for watermark text (hex code or color name)
Transparency Level
 Transparency integer

Transparency level (0-100, where 0 is fully transparent)
Rotation Angle
 RotationAngle integer

Rotation angle in degrees (-180 to 180)
Worksheet Names List
 SelectedWorksheetNames array of string

Names of specific worksheets (when Apply To = By Name)
Worksheet Index List
 SelectedWorksheetIndexes array of integer

Indexes of specific worksheets (when Apply To = By Index)

Returns

Body
AddWatermarkRes

Excel - Delete Rows

Operation ID:
DeleteRows

Delete specific rows from Excel worksheets using row ranges - https://docs.pdf4me.com/integrations/power-automate/excel/delete-rows

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
Worksheet Name
 WorksheetName string

Name of the worksheet to delete rows from (empty for all worksheets)
Row Ranges
 RowRanges string

Comma-separated row ranges to delete (e.g., "1-5,10,15-20")

Returns

Body
DeleteRowsResponse

Excel - Delete Worksheets

Operation ID:
DeleteWorksheet

Delete specific worksheets from Excel workbooks - https://docs.pdf4me.com/integrations/power-automate/excel/delete-worksheets

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
Worksheet Names
 WorksheetNames string

Comma-separated list of worksheet names to delete
Worksheet Indexes
 WorksheetIndexes string

Comma-separated list of worksheet indexes (1-based) to delete

Returns

Body
DeleteWorksheetRes

Excel - Extract Rows

Operation ID:
ExtractRows

Extract specific rows from Excel worksheets and convert to JSON format with advanced filtering options - https://docs.pdf4me.com/integrations/power-automate/excel/extract-rows

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
Worksheet Name
 WorksheetName string

Name of the worksheet to extract from (leave empty for first worksheet)
Has Header Row
 HasHeaderRow boolean

Whether the first row contains column headers
First Row (Start)
 FirstRow integer

Starting row for extraction (0-based, 0 = first row)
Last Row (End)
 LastRow integer

Ending row for extraction (-1 for last row with data)
First Column (Start)
 FirstColumn integer

Starting column for extraction (0-based, 0 = first column)
Last Column (End)
 LastColumn integer

Ending column for extraction (-1 for last column with data)
Exclude Empty Rows
 ExcludeEmptyRows boolean

Skip rows that are completely empty
️ Exclude Hidden Rows
 ExcludeHiddenRows boolean

Skip hidden rows in extraction
️ Exclude Hidden Columns
 ExcludeHiddenColumns boolean

Skip hidden columns in extraction
Export Values As Text
 ExportValuesAsText boolean

Export all cell values as text strings
Export Empty Cells
 ExportEmptyCells boolean

Include empty cells in the output
️ Export as Object Structure
 ExportAsObject boolean

Export data as structured object instead of array
Hyperlink Format
 HyperlinkFormat string

How to handle hyperlinks in cells
Culture & Language Settings
 Culture string

Culture name for data formatting (e.g., en-US, fr-FR, de-DE)

Returns

Body
ExtractRowsRes

Excel - Extract Worksheets

Operation ID:
ExtractWorksheet

Extract specific worksheets from Excel workbooks and return as JSON data - https://docs.pdf4me.com/integrations/power-automate/excel/extract-worksheets

Parameters

Name Key Required Type Description
File Content
 docContent True byte

Input file content from the source
File Name
 name string

Input file name from the source
Worksheet Names
 WorksheetNames string

List of worksheet names to extract
Worksheet Indexes
 WorksheetIndexes integer

List of worksheet indexes (1-based) to extract

Returns

Body
ExtractWorksheetRes

Excel - Merge Files

Operation ID:
MergeFiles

Merge multiple Excel files into a single workbook with support for various output formats - https://docs.pdf4me.com/integrations/power-automate/excel/merge-files

Parameters

Name Key Required Type Description
Output File Name
 OutputFileName string

Name for the merged output file (without extension)
Output Format
 OutputFormat string

Format for the merged output file
Filename
 Filename True string

Original filename with extension
File Content
 FileContent True byte

Base64-encoded file content
Sort Position
 SortPosition True integer

Position in merge order (lowest first)
Worksheets to Merge
 WorksheetsToMerge array of string

Specific worksheets to merge from this file

Returns

Body
MergeFilesRes

Excel - Merge Rows

Operation ID:
MergeRows

Merge rows across multiple worksheets using key columns for data consolidation - https://docs.pdf4me.com/integrations/power-automate/excel/merge-rows

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
Worksheet Numbers
 WorksheetNumbers string

Comma-separated worksheet numbers (1-based) to merge
Merge Key Columns
 MergeKeyColumns string

Comma-separated column numbers (1-based) to use as merge keys
Output Format
 OutputFormat string

Format for the merged output

Returns

Body
MergeRowsRes

Excel - Remove Header Footer

Operation ID:
RemoveHeaderFooter

Remove specific header and footer elements from Excel worksheets - https://docs.pdf4me.com/integrations/power-automate/excel/remove-header-footer

Parameters

Name Key Required Type Description
File Content
 docContent True byte

The Excel file content as base64-encoded string
File Name
 name string

Input file name from the source
Remove Header Left
 RemoveHeaderLeft boolean

Remove left section of header
Remove Header Center
 RemoveHeaderCenter boolean

Remove center section of header
Remove Header Right
 RemoveHeaderRight boolean

Remove right section of header
Remove Footer Left
 RemoveFooterLeft boolean

Remove left section of footer
Remove Footer Center
 RemoveFooterCenter boolean

Remove center section of footer
Remove Footer Right
 RemoveFooterRight boolean

Remove right section of footer
Worksheet Names
 WorksheetNames array of string

Names of worksheets to remove headers/footers from
Worksheet Indexes
 WorksheetIndexes array of integer

Indexes of worksheets to remove headers/footers from
Culture Name
 CultureName string

Culture name for processing

Returns

Body
RemoveHeaderFooterResponse

Excel - Remove Watermark

Operation ID:
DeleteWatermark

Remove watermarks from Excel worksheets by ID or from all worksheets - https://docs.pdf4me.com/integrations/power-automate/excel/remove-watermark

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
Watermark ID
 WatermarkId string

Specific watermark ID to remove (empty to remove all)
Culture Name
 CultureName string

Culture name for processing
Worksheet Names
 WorksheetNames array of string

Names of worksheets to remove watermarks from
Worksheet Indexes
 WorksheetIndexes array of integer

Indexes of worksheets to remove watermarks from

Returns

Body
DeleteWatermarkRes

Excel - Replace Text

Operation ID:
ReplaceText

Find and replace text in Excel worksheets with advanced pattern matching and formatting options - https://docs.pdf4me.com/integrations/power-automate/excel/replace-text

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
Search Text
 SearchText True string

Text to search for
Replacement Text
 ReplacementText True string

Replacement text
Use Regular Expression
 IsExpression boolean

Use regular expressions for search
Match Entire Cell
 MatchEntireCell boolean

Match entire cell content only
Case Sensitive
 CaseSensitive boolean

Perform case-sensitive search
Font Name
 FontName string

Font name for replacement text
Font Color
 FontColor string

Font color (hex code or color name)
Font Size
 FontSize number

Font size for replacement text
Bold
 Bold string

Make replacement text bold
Italic
 Italic string

Make replacement text italic
StrikethroughType
 StrikethroughType string

Make replacement text strikethrough type
UnderlineType
 UnderlineType string

Make replacement text underline type
ScriptType
 ScriptType string

Make replacement text script type
Font Scheme Type
 FontSchemeType string

Set the Font Scheme type to apply to the text
Theme Colour
 ThemeColour string

Set the colour for the 'Replacement Text' according to the theme within the Excel file.
Culture Name
 CultureName string

Culture name for text processing

Returns

Body
ReplaceTextResponse

Excel - Secure File

Operation ID:
SecureExcel

Add password protection and security restrictions to Excel files - https://docs.pdf4me.com/integrations/power-automate/excel/secure-excel

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
Protection Password
 Password string

Password to protect the Excel file
Protect Workbook
 ProtectWorkbook boolean

Enable workbook structure protection
Workbook Password
 ProtectWorkbookPassword string

Separate password for worksbook protection
Protect Worksheets
 ProtectWorksheets boolean

Enable worksheet content protection
Worksheet Password
 WorksheetProtectionPassword string

Separate password for worksheet protection
Protection Type
 WorksheetProtectionType string

Type of worksheet protection to apply
Worksheet Names
 WorksheetNames string

Comma-separated worksheet names to protect
Worksheet Indexes
 WorksheetIndexes string

Comma-separated worksheet indexes (1-based) to protect

Returns

Body
SecureExcelRes

Excel - Unlock File

Operation ID:
UnlockExcel

Remove password protection and security restrictions from Excel files - https://docs.pdf4me.com/integrations/power-automate/excel/unlock-excel

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
File Password
 SecureOnOpenPassword string

Password for file encryption removal
Workbook Password
 WorkbookProtectionPassword string

Password for workbook protection removal
Worksheet Password
 WorksheetProtectionPassword string

Password for worksheet protection removal
Worksheet Names
 WorksheetNames string

Comma-separated worksheet names to unlock
Worksheet Indexes
 WorksheetIndexes string

Comma-separated worksheet indexes (1-based) to unlock
Culture Name
 CultureName string

Culture name for processing

Returns

Body
UnlockExcelRes

Excel - Update Rows

Operation ID:
UpdateRows

Update existing rows in Excel worksheets with JSON data and precise cell targeting - https://docs.pdf4me.com/integrations/power-automate/excel/update-rows

Parameters

Name Key Required Type Description
File Content
 docContent byte

Input file content from the source
File Name
 name string

Input file name from the source
Worksheet Name
 WorksheetName string

Name of the worksheet to update
JSON Update Data
 JsonData string

JSON data containing the updated row values
Start Row
 StartRow integer

Starting row number for updates (1-based)
Start Column
 StartColumn integer

Starting column number for updates (1-based)
Convert Numeric And Date
 ConvertNumericAndDate boolean

Automatically convert numeric and date values
Date Format
 DateFormat string

Format pattern for date values
Numeric Format
 NumericFormat string

Format pattern for numeric values
Ignore Null Values
 IgnoreNullValues boolean

Skip null values when updating
Ignore Attribute Titles
 IgnoreAttributeTitles boolean

Skip JSON property names when updating
Culture Name
 CultureName string

Culture name for data formatting

Returns

Body
UpdateRowsResponse

Definitions

AddTextHeaderFooterRes

Name Path Type Description
Output File Content
 document byte

The processed Excel file content as base64-encoded string
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

AddImageHeaderFooterRes

Name Path Type Description
Output File Content
 document byte

The processed Excel file content as base64-encoded string
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

AddRowsRes

Name Path Type Description
Output File Content
 document byte

The processed Excel file content as base64-encoded string
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

UpdateRowsResponse

Name Path Type Description
Output File Content
 document byte

The processed Excel file content as base64-encoded string
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

DeleteRowsResponse

Name Path Type Description
Output File Content
 document byte

The processed Excel file content as base64-encoded string
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

ExtractRowsRes

Name Path Type Description
Extracted Data (JSON)
 document byte

The extracted rows data as JSON content in a text string
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

ExtractWorksheetRes

Name Path Type Description
Extracted Data (JSON)
 document byte

The extracted worksheet data as JSON content in a text file
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

MergeFilesRes

Name Path Type Description
Merged File Content
 document byte

The merged file content in the specified output format
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

MergeRowsRes

Name Path Type Description
Merged Rows Content
 document byte

The merged rows as Excel file content
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

AddWatermarkRes

Name Path Type Description
Watermarked File Content
 document byte

The watermarked Excel file content as base64-encoded string
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

ReplaceTextResponse

Name Path Type Description
Processed File Content
 document byte

The processed Excel file with replaced text
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

SecureExcelRes

Name Path Type Description
Secured File Content
 document byte

The secured Excel file content as base64-encoded string
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

UnlockExcelRes

Name Path Type Description
Unlocked File Content
 document byte

The unlocked Excel file content as base64-encoded string
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

CsvParseRes

Name Path Type Description
Parsed Content
 document byte

The parsed CSV data as JSON or Excel file content
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

RemoveHeaderFooterResponse

Name Path Type Description
Processed File Content
 document byte

The processed Excel file with removed headers/footers
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages

DeleteWorksheetRes

Name Path Type Description
document
 document byte

The processed Excel file content as base64-encoded string
Success
 Success boolean

Whether the operation completed successfully
ErrorMessage
 ErrorMessage string

Error message if operation failed
Errors
 Errors array of string

List of detailed error messages

DeleteWatermarkRes

Name Path Type Description
Output File Content
 document byte

The processed Excel file content as base64-encoded string
Success
 Success boolean

Whether the operation completed successfully
Error Message
 ErrorMessage string

Error message if operation failed
Error Details
 Errors array of string

List of detailed error messages