Description

Reads the content of the specified cell or range of cells and returns the value as an output.



Attributes

Output

  • DataTable - Stores the data from the range provided as a data table variable.

Input

  • Range - The cell range whose contents would be read.

  • Worksheet - The name of the sheet to be updated. By default, it is set to “Sheet1”.

Options

  • AddHeaders - Omits the first row from the range and considers them as column headers.

Common

  • ContinueOnError - The Boolean value to specify whether to continue executing the next activities even if there is an error thrown on this activity.

Misc

  • DisplayName - Renames the activity.


Example

For this example, this is what the sample Spreadsheet contains:



  1. Add an Excel Sequence activity inside the initial Sequence.
  2. In the File Path field, search for and select your Spreadsheet document by clicking the browse button.
  3. Create a System.Data.DataTable variable and name it dt.
  4. After the Excel Sequence activity, add a Read Range activity.
  5. In the DataTable field under Properties, add the dt variable.
  6. In the Read Range Worksheet field, write Employees (or the name of the sheet you would use).
  7. In the Read Range Range field, write A2:D2.
  8. Create a String variable and name it output.
  9. After the Read Range activity, add an Output Data Table activity.
  10. In the Output Data Table Text field under Properties, add the output variable.
  11. In the Output Data Table DataTable field, insert the dt variable.
  12. After the Output Data Table, add a Write Line activity.
  13. Lastly, in the Text field, add the output variable. 

    The use case should look as the following screenshot:



The output should look like this in the Output panel: