Gembox Excel CRUD

Reads, creates, updates, or deletes rows in an Excel workbook, updates document properties, or recalculates formulas using the GemBox.Spreadsheet library.

Purpose

Use this task to interact with Excel files on the worker machine without requiring Microsoft Excel to be installed. It covers the full range of spreadsheet manipulation needed in automation workflows: reading structured data for downstream processing, appending new records, updating individual cells, removing obsolete rows, stamping workbook metadata, and forcing formula recalculation after bulk edits. A GemBox service account with a valid API key must be configured before this task can run.

Inputs

Field	Type	Required	Description
Mode	Dropdown	Yes	Operation to perform: READ, CREATE, UPDATE, DELETE, PROPERTIES, or CALCULATE.
Excel File Path	Text	Yes	Absolute path to the .xlsx file on the worker machine.
Worksheet Name	Text	Yes	Name of the worksheet tab to operate on. Not required for PROPERTIES or CALCULATE modes.
Number of Columns	Text	No	How many leading columns to read from each row. Used in READ mode.
Cell Values	Multi-line Text	No	JSON array of values for the new row, for example ["Name", "Department", 85000]. Used in CREATE mode.
Row Number	Text	No	Zero-based row index of the cell to update. Used in UPDATE mode.
Column Number	Text	No	Zero-based column index of the cell to update. Used in UPDATE mode.
Value	Text	No	New cell value to write. Used in UPDATE mode.
Row Numbers	Multi-line Text	No	Single row number or JSON array of zero-based row numbers to delete, for example [1,3,5]. Used in DELETE mode.
Built-In Properties	Key-Value Pairs	No	Built-in document properties to set, such as Title or Subject. Used in PROPERTIES mode.
Custom Properties	Key-Value Pairs	No	Custom document properties to set. Used in PROPERTIES mode.

Visibility Rules

Number of Columns is only shown when Mode is set to READ. Cell Values is only shown when Mode is set to CREATE. Row Number is only shown when Mode is set to UPDATE. Column Number is only shown when Mode is set to UPDATE. Value is only shown when Mode is set to UPDATE. Row Numbers is only shown when Mode is set to DELETE. Built-In Properties is only shown when Mode is set to PROPERTIES. Custom Properties is only shown when Mode is set to PROPERTIES.

Operations

READ returns the worksheet contents. CREATE appends a row and returns the new row index. UPDATE and DELETE modify the file in place. PROPERTIES sets workbook metadata. CALCULATE triggers formula recalculation across the entire workbook.

Outputs

Name	Description
ExcelData	JSON-serialized table of row data read from the worksheet. Only present after a READ operation.
NewRowIndex	Zero-based index of the newly appended row. Only present after a CREATE operation.