Update Cell

Updates a value within a row on Excel Online.

Options

Field Definition Type Required

Workbook

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, then the list of workbooks from your account in the Workbook dropdown will be depopulated; 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.	String	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

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, then the list of workbooks from your account in the Workbook dropdown will be depopulated; 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.

String

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.	String	TRUE
Value	New value.	String	TRUE
Formula	Add an excel formula. For example, `=SUM(A2:A10), = CONCAT(A1;B5),=MAX (number1, [number2], ...)`.	String	FALSE
Format	Number format. Excel Online uses special inner format. It can be read via 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);_($* "-"??_);_(@_)`	String	FALSE

Output

Field	Definition	Type
Status Code	Result of your HTTP request. See HTTP status codes.	Number

Update Cell

Options

Input

Output

Related topics