> For the complete documentation index, see [llms.txt](https://docs.visualyze.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.visualyze.ai/integrations/office-365/activities/excel/untitled.md).

# Read Row

Retrieves cell values from a specified row.

This activity retrieves cell values from a specific row in a user-specified workbook's worksheet using the Microsoft Graph [Get range](https://docs.microsoft.com/en-us/graph/api/range-get?view=graph-rest-1.0\&tabs=http) API.

### Input

* **Connection Id:** [`GraphServiceClient Variable`](/getting-started/rpa-studio/variables.md#graphserviceclient) <mark style="color:red;">`Required`</mark>\
  Specifies the office 365 connection id.
* **Sheet Name:** [`String Argument`](/getting-started/rpa-studio/arguments.md#string)  <mark style="color:red;">`Required`</mark>\
  Specifies the name of the sheet from which data is to be read.
* **Starting Cell:** [`String Argument`](/getting-started/rpa-studio/arguments.md#string)\
  Specifies the address of the row's starting cell. Input the address in A1-style notation. This property doesn't support range values like "A1:A3".
* **Workbook:** [`Object Argument`](/getting-started/rpa-studio/arguments.md#types-of-arguments)  <mark style="color:red;">`Required`</mark>\
  Specifies the [DriveItem ](https://docs.microsoft.com/en-us/graph/api/resources/driveitem?view=graph-rest-1.0)of the Excel workbook whose data are to be retrieved. We can also specify the output variable of the [Find Files And Folders](/integrations/office-365/activities/files/find-files-and-folders.md) activity (which is **First** or **Results**) directly as input in this property or use the output variable of the [Create Workbook](/integrations/office-365/activities/excel/create-workbook.md) activity (**Workbook**). If we are using the **Results** property of the **Find Files And Folders** activity then we can directly specify the element in the array.\
  For example : Results\[1].

### Options

* **Value Type:**\
  Specifies the type of data that is to be read from the given excel file. The available options are:
  * **Values -** Returns the coded value in the specified cell. For ex:- If the value in the specified cell is **15.00** then returned coded value will be **15**.
  * **Formulas -** Returns the formula of the specified cell. If the cell doesn't contain any formula it returns the value of the cell by default.
  * **Text -** Returns the text value of the specified cell. For ex:- If the value in the specified cell is **15.00** then returned text value will be **15.00** itself.

### Output

* **Row:** [`Object Variable`](/getting-started/rpa-studio/variables.md#object)  <mark style="color:red;">`Required`</mark>\
  Specifies row values as an array of objects.