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)