Excel Multi-Sheet Editor icon

Excel Multi-Sheet Editor

Edit multi-sheet Excel files - read, write, list sheets with full style and formula preservation

Actions3

Add Rows to End

AI-generated

Summary

Append rows of values or formulas to the selected worksheet in an Excel workbook, then return the updated workbook as a binary file. Supply the workbook in the configured binary field, or the node creates a new workbook with a Sheet1 sheet when no input file is present.

Inputs

  • Input Binary Field — Binary property containing the Excel file; defaults to data. If absent, a new workbook is created.
  • Sheet Name — Worksheet to append to; defaults to Sheet1. A missing sheet is created.
  • Output File Name — Optional output filename. The node adds the .xlsx extension if needed; when empty, it keeps the input filename or uses workbook.xlsx for a new workbook.
  • Data Format — Choose Define Below to enter rows in Data to Add, or From JSON Property to read them from the incoming item's JSON.
  • JSON Data Property — When using From JSON Property, the input JSON field to read; defaults to excelData.
  • Data to Add — Rows to append as an array of arrays. Strings beginning with = are written as formulas. Object rows are converted to arrays of their values.
  • Target Columns — Optional comma-separated column letters or numbers, such as A,B,C or 1,2,3, to direct values to columns in order. Unmapped values continue from column A.
  • Add Empty Row Before — When enabled and the worksheet's last row contains content, leaves one empty row before the appended data. Defaults to false.
  • Output Binary Field — Binary property name for the updated workbook; defaults to the input binary field name, or data if there is no input file.

Output shape

One output item per input item, containing JSON metadata and the updated Excel workbook as binary data.

JSON metadata includes excelOperation, sheetModified, rowsAffected, sheetNames, and outputFileName, alongside the incoming JSON. The updated file uses the Office Open XML spreadsheet MIME type. If the input data is not an array, execution errors; with Continue On Fail enabled, an error message is returned in JSON without an output workbook.

Examples

Example 1: Append records to an existing worksheet

Provide an Excel file in the configured binary field, choose its worksheet, then define rows or reference an array in the input JSON. Optionally map values to selected columns or leave an empty row before appending.

Links

Discussion