Update Cell

Update a value within a row in an Excel Online worksheet.

Due to third-party API limitations, this action card doesn't update workbooks that are stored in OneDrive shared libraries. Updates are limited to workbooks stored in personal OneDrive storage.

If you move a workbook from personal OneDrive storage to a shared library, the Microsoft API may continue to return the data of the version of the file at the time when it was moved. If you return the file to personal storage, the Microsoft API may return data for both the original file and the updated file after it was returned to personal OneDrive storage.

Options

Field	Definition	Type	Required
Workbook	List of workbooks available in your account. Workbook is another word for your Excel files. If you select a Workbook from the dropdown, ignore the Workbook ID field. If you select -- Enter Workbook ID -- from the dropdown list, then enter an ID in the Workbook ID field.	Dropdown	TRUE
Workbook ID	Option to specify a Excel Online workbook by ID. Example of a workbook ID: 015PGUOTTY6ZMVGBRB65DLDRED7VJJEJTP To get the ID for an Excel Online workbook, see Get a DriveItem resource.	Text	FALSE
Worksheet	List of worksheets available in the specified workbook. A worksheet is an individual spreadsheet within a workbook, displayed as a tab in an Excel file.	Dropdown	TRUE

Field

Definition

Type

Required

Workbook

List of workbooks available in your account. Workbook is another word for your Excel files.

If you select a Workbook from the dropdown, ignore the Workbook ID field.

If you select -- Enter Workbook ID -- from the dropdown list, then enter an ID in the Workbook ID field.

Dropdown

TRUE

Workbook ID

Option to specify a Excel Online workbook by ID.

Example of a workbook ID: 015PGUOTTY6ZMVGBRB65DLDRED7VJJEJTP

To get the ID for an Excel Online workbook, see Get a DriveItem resource.

Text

FALSE

Worksheet

List of worksheets available in the specified workbook. A worksheet is an individual spreadsheet within a workbook, displayed as a tab in an Excel file.

Dropdown

TRUE

Input

Field	Definition	Type	Required
Cell
Cell Reference	In format A1, for the first cell on the spreadsheet.	Text	TRUE
Value	New value.	Text	TRUE
Formula	Add an Excel formula. For example, =SUM(A2:A10), = CONCAT(A1;B5),=MAX (number1, [number2], ...).	Text	FALSE
Format	Number format. Excel Online uses special inner format. It can be read through the Format output field on the Get Cell Value card. Formats: Number: 0 Currency: $#,##0 Date: m/d/yyyy Percentage: 0.00% Fraction: # ?/? Scientific: 0.00E+00 Text: @ Accounting: _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)	Text	FALSE

Output

Field	Definition	Type
Status Code	Result of the operation. The connector returns an HTTP status code that indicates whether the action taken by the card succeeded or failed. For example: A 201 Created status code indicates success where a new resource was created. A 403 Forbidden error indicates that the HTTP request wasn't processed because the necessary permissions were missing. For a full list of possible status codes, see HTTP status codes.	Number

Field

Definition

Type

Status Code

Result of the operation. The connector returns an HTTP status code that indicates whether the action taken by the card succeeded or failed. For example:

A 201 Created status code indicates success where a new resource was created.
A 403 Forbidden error indicates that the HTTP request wasn't processed because the necessary permissions were missing.

For a full list of possible status codes, see HTTP status codes.

Number

Update Cell

Options

Input

Output

Related topics