XLSX icon

XLSX

Manipulate workbooks

Actions9

Delete Columns

AI-generated

Summary

Delete a specified number of columns from a worksheet, shifting the remaining columns left. The operation edits the workbook and returns it as an XLSX binary file.

Inputs

  • Sheet Name — Worksheet to edit; leave empty to use the first sheet.
  • Start Column — 1-based column number where deletion begins; defaults to 1.
  • Number of Columns — Number of columns to delete; defaults to 1.
  • Input Binary Field — Binary field containing the existing XLSX file. If no input item has this field, the node creates a new workbook in memory.
  • Output Binary Field — Binary field for the resulting XLSX file; defaults to data.
  • Output File Name — File name attached to the output binary; defaults to spreadsheet.xlsx.

Output shape

A single item containing the resulting workbook in a binary field and success: true in its JSON.

The output binary field and filename are configurable. The JSON also carries forward the first input item's JSON fields, if present. If the named sheet is missing, the operation returns an error; this operation does not create missing sheets.

Links

Discussion