Skip to main content
Docs
Go to the Studio
Roberty Studio
RPAExcel Online

Cell > Get value

Cell > Get value

Gets the value of a specific cell in an Excel file hosted on OneDrive or SharePoint.


Options​

Drive type​

Select where the Excel file is stored: SharePoint or OneDrive. The selected option defines which source field is shown next.

SharePoint or OneDrive drive​

Shown when the Drive type is SharePoint. Select the action that gets the SharePoint drive where the file is stored: Get a drive from the list or Get drive by name.

OneDrive account​

Shown when the Drive type is OneDrive. Select the OneDrive Login action set up in the flow.

Excel path in the drive​

Enter the path of the Excel file from the root of the drive, including the name and extension, for example Reports/sales.xlsx.

Spreadsheet tab name​

Enter the name of the tab that contains the cell, for example Sheet1.

Cell to be edited​

Enter the address of the cell to read, for example A1 or B5.

Returns​

Javascript code​

js
actions["action-id"].value // value retrieved from the cell (Text)
actions["action-id"].valueType // type of value retrieved from the cell (Text)
actions["action-id"].formula // formula retrieved from the cell (if applicable) (Text)
actions["action-id"].success // indicates if the cell value was successfully retrieved (Boolean)

Field selection​

  • value — value retrieved from the cell (Text)
  • valueType — type of value retrieved from the cell (Text)
  • formula — formula retrieved from the cell (if applicable) (Text)
  • success — indicates if the cell value was successfully retrieved (Boolean)

Rules and Conditions​

  • The Drive type, Excel path in the drive fields and the matching source (SharePoint or OneDrive drive or OneDrive account) are required.
  • Also required: Spreadsheet tab name and Cell to be edited.
  • Despite the Cell to be edited label, this action only reads the cell; the file is not changed.
  • If Microsoft Graph rejects the operation (item not found, insufficient permission, etc.), the action fails with the error message returned by the API.