Read Cell

Reads the value in a specific cell.

This activity retrieves the value of a specific cell in a user-specified workbook using the Microsoft Graph Get range API.

Input

• Connection Id: GraphServiceClient Variable Required Specifies the office 365 connection id.

• Sheet Name: String Argument Required Specifies the name of the sheet from which data is to be read.

• Cell Address: String Argument Specifies the address of the cell from which the data is to be read. Input the address in A1-style notation. This property doesn't support range values. For example: "A1:A3".

• Workbook: Object Argument Required Specifies the DriveItem of the Excel workbook whose data are to be retrieved. We can also specify the output variable of the Find Files And Folders activity (which is First or Results) directly as input in this property or use the output variable of the Create Workbook 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 are 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

• Cell Value: String Variable Required Specifies the contents of the cell as a string.