Microsoft 365 Excel

Current value of a cell

This query returns the current value of a single cell in your workbook.

Developer info

API endpoint slug: excel_365.cell_value
Runtime method: performQuery("excel_365.cell_value"}

Query fields

Path Text input > Path to a folder

Label: Enter the folder path...
Helper text: Format: folders separated by "/" like "Documents/Expense reports"
Slug: path
Required: false
Can have default value: true

Filename Text input > File name

Label: and enter the filename
Helper text: E.g. "report.xlsx"
Slug: filename
Required: true
Can have default value: true

Cell Text input > Other

Label: Which cell?
Helper text: Use A1 notation for a single cell e.g. A2 or B10
Slug: cell
Required: true
Can have default value: true

Worksheet name Text input > Other

Label: The name of the worksheet
Helper text: E.g. Sheet1 or Project Budget
Slug: worksheet_name
Required: true
Can have default value: true

Ingredients

Value The current value of the cell.

Slug: value
Filter code: Excel365.cellValue.Value
Type: String
Example: $120.00

Cell The address of the cell.

Slug: cell
Filter code: Excel365.cellValue.Cell
Type: String
Example: Sheet1!A20

Checked at The timestamp when the value of the cell was fetched.

Slug: checked_at
Filter code: Excel365.cellValue.CheckedAt
Type: Date with time (ISO8601)
Example: 2020-07-08T04:17:06+05:00