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 |