Get Cell Value
Read values and other properties for a cell in an Excel Online worksheet.
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 |
Output
| Field | Definition | Type |
|---|---|---|
| Cell Text | Text in the specified cell. | String |
| Cell Value | Value of the cell. | String |
| Type | Type of content in the cell. | String |
| Format | Format for content in the cell. | String |
| Column Hidden | Indicates if the column is hidden. | Boolean |
| Row Hidden | Indicates if the row is hidden. | Boolean |
| Hidden | Indicates if the cell is hidden. | Boolean |
| Formula | Excel online formula. | String |