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

List Sheets

AI-generated

Summary

Lists the worksheet names in the Excel workbook found in the input item's binary field. Set Input Binary Field to the field containing the workbook; if that binary field is missing, the node creates an empty workbook with a single Sheet1 worksheet.

Inputs

  • Input Binary Field — Binary field containing the Excel workbook; defaults to data. If the field is absent, the operation lists sheets from a newly created workbook containing Sheet1.

Output shape

One output item per input item, with the input JSON fields preserved and sheet listing fields added.

Adds operation (listSheets), sheetCount, sheetNames (an array of names), and sheets (objects with 1-based index and name). It does not return a modified workbook binary.

Links

Discussion