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 Range at Position

AI-generated

Summary

Writes a two-dimensional data array into a worksheet in the input Excel workbook, starting at the configured cell. Existing non-empty cells are skipped by default; formulas can be supplied as strings beginning with =.

Inputs

  • Input Binary Field — Binary property containing the Excel workbook; defaults to data. If it is absent, the operation starts with a new workbook containing Sheet1.
  • Sheet Name — Worksheet to edit; defaults to Sheet1. If the named sheet does not exist, the operation creates it.
  • Start Cell — Cell reference where the first value is written; defaults to A1. An unrecognized reference falls back to A1.
  • Data Format — Choose Define Below to use Data to Add, or From JSON Property to read the array from the current item's JSON. Defaults to Define Below.
  • Data to Add — Array of rows to write when using Define Below. Each row can be an array, an object (its values are used in property order), or a scalar. A string value beginning with = is written as a formula.
  • JSON Data Property — When using From JSON Property, names the current item's JSON property containing the data array; defaults to excelData.
  • Target Columns — Optional comma-separated column letters or numbers. Values are mapped to these columns in order; values without a corresponding target column use consecutive columns starting at Start Cell.
  • Options: Overwrite Existing Cells — When enabled, writes over existing values at the target cells. Defaults to false; otherwise non-empty target cells are left unchanged.
  • Options: Clear Target Columns Before Insert — When enabled, clears values and styles in the selected target columns across all existing rows before writing. If Target Columns is empty, clears columns based on the data width, beginning at Start Cell's column.
  • Output File Name — Optional output workbook filename. Adds the .xlsx extension if missing; when empty, uses the input filename or workbook.xlsx.
  • Options: Output Binary Field — Binary property name for the resulting workbook; defaults to the input binary field name, or data if none is set.

Output shape

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

The binary field is named by Output Binary Field. JSON preserves the input item's fields and adds excelOperation, sheetModified, rowsAffected (number of input rows), sheetNames, and outputFileName. Errors are thrown unless Continue On Fail is enabled, in which case an error is added to that item's JSON.

Links

Discussion