Update Cell

Updates a value within a row on Excel Online.

Options

Choose a workbook and worksheet in order to update a cell.

  • Workbook(dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.

  • Worksheet(dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.

Input Fields

  • Cell

    • Cell Reference(text): In format like " A1", for the first cell on the spreadsheet.

    • Value(text): the new value.

    • Formula(text): Add an excel formula.

    e.g.: =SUM(A2:A10), = CONCAT(A1;B5),=MAX (number1, [number2], ...) etc

    • Format(text): Number format. Excel Online uses special inner format. It can be read via Get Cell ValueFormat output

 

Short list of formats

  • Number - 0
  • Currency - $#,##0
  • Date - m/d/yyyy
  • Percentage - 0.00%
  • Fraction - # ?/?
  • Scientific - 0.00E+00
  • Text - @
  • Accounting - _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

Output Fields

  • Response

    • Status Code (number)

See Also

Excel Online connector

About the elements of Okta Workflows

Excel Online API documentation