Read Table Row

Read Table Row feature enables you to automatically fetch data from a specified row of an Excel table.

 

Using Read Table Row Feature

  1. Make sure the prerequisites for using Office 365 activities are met.
  2. In the Canvas Tools pane, click Office 365 Services to expand the tool and view the associated activities. 
  3. Drag the Excel 365 activity inside the Office 365 Application Activity. Ensure that the output token of the OAuth process is passed on to the Excel activity for authentication. For more information, see OAuth Activity.
    1. The validation error symbol disappears when you select relevant values in the particular field from the available list. For example,  Access Token, Append Range, and Output. 


  4. In the Access Token list, select the output parameter holding the value of access token from the OAuth activity to pass in the Excel 365 activity. For more information, see OAuth activity.the Feature list, select Read Table Row.
  5. In the Feature list, select Read Table Row.
    1. Click the  (Setting) icon to configure the input parameters. The Input Configuration screen appears.


  6. Define all the input parameters In arguments and output parameters as Out arguments in the Argument bar to make it available for the selection. 

    Read Table Row feature does not have any optional parameters to define. 
  7. You can select the Is Default Value checkbox to set the selected input parameter as the default value.
    1. Mandatory Options:
      1. Corresponding to the workbook parameter, select the argument holding the workbook path along with the workbook name and its file extension. For example, RDtest\EmployeeDetails.xlsx.

        If the excel file is present at the root folder location, you must define only the workbook name and its file extension. For example, EmployeeDetails.xlsx.
      2. Corresponding to the worksheet parameter, select the argument holding the name of the Excel sheet from which you want to read the column data.
      3. Corresponding to the tableName parameter, select the argument holding the table name from which you want to read the column data.
      4. Corresponding to the index parameter, select the argument holding the index value of the row whose data you want to read.
         

        NOTE:  

        The row indexing starts from 0. This signifies that if you want to read the 3rd row of the specified table, you must enter the index parameter value as 2.

 

  1. Once done, click Confirm.
  2. In the Output dropdown list, select an Out argument which should store the result. The argument should be of Out Direction.
  3. Save the process. 
  4. In the Tool bar, click Setup Environment.
  5. Once environment setup is completed perform the Test Run.

    The Read Table Row feature is configured.

    The row data read is in the array format. Following is the sample output received:

    [
      [
        3,
        “Max”,
        “Florida”
      ]
    ]