PDF4me ExcelInstall

Summary

Perform search and replace operations on text within an Excel file, optionally applying custom formatting to the replaced text.

Inputs

• Excel File Input Method (required) — Choose how to provide the Excel file: binary data from a previous node, a base64 encoded string, or download it from a URL.
• Binary Data Property Name (required) — When using binary data input, specify the binary property name containing the Excel file (usually 'data').
• Base64 Encoded Excel Content (required) — When using base64 input, provide the Excel file content as a base64 encoded string.
• Excel File URL (required) — When using URL input, specify the publicly accessible URL to download the Excel file.
• Replace Operations (required) — Define one or more search and replace rules including search text, replacement text, options for regex, match scope, case sensitivity, and optional formatting for replacement text.
• Culture Name — Specify the culture for text processing, e.g., 'en-US' for English (United States) or others for locale-specific processing.
• Output File Name — Set the filename for the processed Excel file with replacements applied.
• Source Document Name — Name of the input Excel file used for reference during processing.
• Output Binary Data Name — Name for the binary data property in the node output to access the processed Excel file.

Output shape

a single binary file representing the Excel document with specified text replaced as configured.

The output file is accessible via the specified Output Binary Data Name property in n8n. The node supports multiple replace operations with detailed control over search behavior and formatting. Errors can be handled according to the node's continueOnFail setting.