PDF4me ExcelInstall

Summary

Merge rows in one or more worksheets of an Excel file based on matching values in specified key columns, producing a single merged output file in a chosen format.

Inputs

• Excel File Input Method (required) — Choose how to provide the Excel file: from binary data of previous node, base64 encoded string, or download from a URL.
• Binary Data Property Name (required) — Name of the binary property containing the Excel file (used when input method is binary data).
• Base64 Encoded Excel Content (required) — Base64 string representing the Excel file content (used when input method is base64).
• Excel File URL (required) — Public URL to download the Excel file (used when input method is URL).
• Worksheet Numbers — Comma-separated list of 1-based worksheet numbers to process; leave empty to merge rows from all worksheets.
• Merge Key Columns — Comma-separated column letters or numbers (1-based) that determine which rows to merge based on matching values.
• Output Format — File format for the merged output file; options include XLSX, XLSB, XLS, or CSV.
• Output File Name — Filename for the merged output Excel file.
• Source Document Name — Name of the original Excel file, used internally for reference and processing.
• Output Binary Data Name — Name assigned to the output binary data to access the processed file in the workflow.

Output shape

A single binary file representing the Excel file with merged rows, formatted per the selected output format.

The output contains the processed Excel file data as binary under the specified output binary data name. If multiple input items are processed, the node outputs corresponding merged files in an array. Errors per item are reported if 'Continue On Fail' is enabled.