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 Value Format 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)