PDF4me ExcelInstall

Summary

Update specified rows in an Excel worksheet by providing JSON data with new values, modifying cells starting from a given row and column in the indicated worksheet.

Inputs

• Excel File Input Method (required) — Choose how to provide the Excel file to update, either from previous node binary data, a base64 encoded string, or a downloadable URL.
• Binary Data Property Name (required) — Specify the binary property name containing the Excel file if using binary data input method.
• Base64 Encoded Excel Content (required) — Provide the Excel file as a base64 encoded string when this input method is selected.
• Excel File URL (required) — URL to download the Excel file when this input method is selected.
• Worksheet Name (required) — Name of the worksheet where the rows will be updated.
• JSON Data (required) — JSON array or string representing the row values to update in the worksheet.
• Start Row (required) — The 1-based index row number to begin updating rows.
• Start Column (required) — The 1-based index column number to begin updating rows.
• Convert Numeric and Date Values — Flag to automatically convert numeric and date values to proper types.
• Date Format — Format pattern for date values (e.g., yyyy-MM-dd).
• Numeric Format — Format pattern for numeric values (e.g., N2 for two decimals).
• Ignore Null Values — If true, cells with null values in JSON data will not overwrite existing cells.
• Ignore Attribute Titles — If true, JSON property names are ignored; only values are written sequentially.
• Culture Name — Culture name (e.g., en-US) used for data formatting.
• Output File Name — Name for the updated Excel file produced.
• Source Document Name — Reference name of the original Excel file.
• Output Binary Data Name — Name of the output binary property containing the updated file.

Output shape

a single item with binary Excel file data containing the updated worksheet rows

The output includes the processed Excel file in binary form with the rows updated as specified. The output binary property name can be configured. Errors on invalid inputs or data mismatches may cause operation failure unless continueOnFail is enabled.