Update Cell
Updates a value within a row on Excel Online.
Options
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 |
Dropdown | TRUE |
Workbook ID |
Option to specify a Excel Online workbook by ID. Example of a workbook ID: 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:
|
String | FALSE |
Output
Field | Definition | Type |
---|---|---|
Status Code |
Result of your HTTP request. See HTTP status codes. |
Number |