Excel AI icon

Excel AI

Perform CRUD operations on Excel files with AI Agent support

Actions7

Row → Update Row

AI-generated

Summary

Updates a specific row in an Excel file using JSON or individual field definitions.

Inputs

  • inputMode (required) — How to provide the Excel file: 'filePath' for the file system or 'binaryData' for binary data.
  • filePath (required) — Absolute path to the Excel file (required when inputMode is filePath).
  • binaryPropertyName (required) — Name of the binary property containing the Excel file (required when inputMode is binaryData).
  • sheetName — Name of the worksheet to operate on. If not specified, the first worksheet will be used.
  • rowNumber (required) — Target row number (1-based, row 1 is header).
  • updateMode (required) — How to specify the data to update: '' for a JSON object or 'fields' for individual fields.
  • updatedData (required) — Data to update as JSON object. Only specified columns will be updated (required when updateMode is ).
  • updateFields — Fields to update. Use Add Field to specify each column individually (required when updateMode is fields).
  • autoSave — Whether to automatically save changes to the file (default true, only applies to filePath mode).

Output shape

a single object containing success status, operation type, row number, updated fields, and a message.

The operation returns details about the update, including which fields were successfully updated and any fields that were skipped (if they did not exist in the worksheet).

Examples

Example 1: Update specific columns in a row using a JSON object.

Row 5 in 'Sheet1' with updatedData: { 'Status': 'Completed', 'Notes': 'Task finished' }

Example 2: Update individual fields using the Fields mode.

Row 3 in 'Sheet1' with updateFields containing Field Name 'Email' and Value 'new@example.com'

Links

Discussion