Update Cell

Updates a value within a row on Excel Online.

Options

Field Definition Type Required
Workbook A list of workbooks available to the account. Workbook is another word for your Excel files. Dropdown FALSE
Worksheet A list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files. Dropdown FALSE

Input

Field Definition Type Required
Cell
Cell Reference In format A1, for the first cell on the spreadsheet. String TRUE
Value the 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

The result of your HTTP request. See HTTP status codes.

Number

Related topics

Excel Online connector

About the elements of Okta Workflows

Excel Online API documentation