Read Column

Retrieves cell values from a column.

This activity retrieves cell values from a specific column in a user-specified workbook's worksheet 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.

• Starting Cell: String Argument Specifies the address of the column's starting cell. Input the address in A1-style notation. This property doesn't support range values like "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 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

• Column: Object Variable Required Specifies column values as an array of objects.