Description

Selects the specified range from an Excel spreadsheet.



Attributes

Input

  • Range - The range to be selected.

  • Worksheet - The name of the sheet to be selected.

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 Excel Sequence File Path field, search for and select your Spreadsheet document by clicking the browse button.
  3. Inside the Excel Sequence, add a Select Range activity.
  4. In the Select Range Worksheet field, write "Info" (or the name of the sheet you would use).
  5. In the Select Range Range field, write "A1:A2". 

    The use case should look as the following screenshot:



After executing, the cells A1:A2 should be selected.