Excel API icon

Excel API

Access Excel files via API with concurrent safety

Actions4

Update

AI-generated

Summary

Update rows in a specified Excel worksheet file by matching values in a designated lookup column and setting new values for specified columns.

Inputs

  • File Name (required) — Select an Excel file from the server by exact filename or from a searchable list.
  • Sheet Name — Select a worksheet from the Excel file by exact name or from a searchable list.
  • Lookup Column (required) — Column name from the first row headers used to find matching rows for update.
  • Lookup Value (required) — Value to search for in the lookup column; can be an expression.
  • Process Mode (required) — Choose to update all matching rows or just the first matching row.
  • Values to Set (required) — JSON object specifying column names as keys and their desired new values to set in matched rows.

Output shape

a list of JSON objects representing the API response per updated row or an error.

Returns the API's JSON response indicating success and count of updated rows. Throws an error if no matching rows are found for the given lookup criteria.

Links

Discussion