UiPath Documentation
activities
latest
false
Productivity activities

Get Selected Range

Get Selected Range activity that returns the selected range as a String variable in Excel.

UiPath.Excel.Activities.Windows.Business.GetSelectedRangeX

Description​

Returns the selected range as a String variable.

Project compatibility​

Windows - Legacy | Windows

Configuring the activity​

Designer panel​

  • Workbook file - The file from which a specific range should be retrieved.
  • Save to - The Range variable that is retrieved. The selection applies only to the active sheet and requires Excel to be opened. Also, the option should return a Range and not a String.

Properties​

Common​

  • DisplayName - The display name of the activity.
Input​
  • Target Workbook - The workbook from which to get the selected range. The field is automatically populated when the activity is created inside a Use Excel File context.

Misc​

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output​

  • Range - The retrieved range, stored in a String variable. This field supports only strings and String variables.
Note:

You can use the Get Selected Range activity as a confirmation tool or as an information extractor tool.

  • Confirmation tool: when used together with the Select Range activity, the Get Selected Range activity confirms the automatically selected range.
  • Information Extractor Tool: when used as a standalone activity, Get Selected Range extracts the information and notifies the user about the manually selected range.

Example of Using the Get Selected Range Activity​

To exemplify how to use this activity, we have built an automation project which opens an Excel workbook and then displays a message box, in which time you can select a range which is then copied and displayed in another message box.

Was this page helpful?

Connect

Need help? Support

Want to learn? UiPath Academy

Have questions? UiPath Forum

Stay updated