PDF4me ExcelInstall

Summary

Add one or more rows of data to an existing Excel file's specified worksheet, starting from a given row and column position, optionally targeting a named Excel table.

Inputs

• Excel File Input Method (required) — Choose how to provide the Excel file for processing: from a previous node's binary data, base64 encoded string, or download from a URL.
• Binary Data Property Name (required) — Name of the binary property containing the Excel file when using previous node's binary data input (default 'data').
• Base64 Encoded Excel Content (required) — Base64 string of the Excel file content if input method is base64.
• Excel File URL (required) — Publicly accessible URL to download the Excel file if input method is url.
• Worksheet Name (required) — Name of the worksheet within the Excel file to add rows to.
• JSON Row Data (required) — JSON array of objects representing rows to add; each object corresponds to a row with key-value pairs as columns.
• Insert From Row (required) — 1-based row number indicating where to start inserting new rows.
• Insert From Column (required) — 1-based column number indicating where to start inserting new columns.
• Target Excel Table — Optional name of an existing Excel table to which rows should be added.
• Excel Row Number — Starting row number for insertion if targeting an Excel table.
• Convert Numeric and Date Values — Boolean flag to convert numeric and date strings in JSON data to native Excel types (default true).
• Date Format Pattern — Format pattern to apply to date values when converting (default 'yyyy-MM-dd').
• Numeric Format Pattern — Format pattern for numeric values, e.g., number of decimals or currency (default 'N2').
• Skip JSON Property Names — Whether to insert only values, ignoring JSON property (column) names.
• Skip Null Values — Whether to skip null values from the JSON data during insertion.
• Culture & Language Settings — Culture name string for formatting (default 'en-US').
• Output File Name — Filename to assign the resulting Excel file with added rows (default 'excel_with_rows.xlsx').
• Source Document Name — Name of the original Excel file used for reference during processing.
• Output Binary Data Name — Name of the binary property in node output where the processed Excel file is stored (default 'data').

Output shape

a single binary file with the updated Excel content

The output contains one binary data property (name configurable) holding the Excel file updated with the added rows, preserving original file structure except for added rows. No paging or multiple records are returned.