Read Range
Retrieves a range of values from a user specified workbook.
Last updated
Retrieves a range of values from a user specified workbook.
Last updated
This activity retrieves a range of cell values from a user-specified excel workbook using the Microsoft Graph Get range API.
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.
Range: String Argument
Specifies the range of cells that are to be read. If left blank, the whole sheet is read. Input the cell range in A1-style notation like "A1:A5".
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].
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.
Add Headers: If set to true, the first row from the range is also added to the resultant Datatable as column headers.
Datatable:DataTable Variable
****Specifies a range of values retrieved as a DataTable
