Skip to main content

What can we help you with?

Search

Sort Range

Sergei Ostapov
  • Updated

Description

This action allows you to sort the range of data in the Excel file by column. Note that the data is sorted as strings.

Studio Pro supports Microsoft Excel .xls and .xlsx file formats.

 

As of the 8.3 update, there are two ways of interacting with MS Excel - Microsoft Native and Generic. Navigate to the menu "Settings"  → "Microsoft activities" to choose a method.

Microsoft Native uses standard Microsoft methods to interact with the Excel application. It requires Excel to be installed on your computer and extends the capabilities of interacting with all Excel functionalities.
Generic does not require Excel to be installed and may have some Excel functionalities limitations.

 

 

Parameters

Path

  1. Set a value — allows you to set a path to the target Excel file. By clicking PICK you can find the desired file using file explorer.  
  2. Calculate a value — lets you use a special formula or method to set a path to the target file. 
  3. Save the previous step result — takes the path to the target file from the result of the previous step in the workflow.

 

Range

  1. Set a value — here you can manually specify the range to be sorted by column. Note that you must use the A:B format for these coordinates, where A represents the left-top value and B represents the right-bottom value.
  2. Calculate a value — lets you use a special formula or method to set a range.
  3. Save the previous step result — takes the range from the result of the previous step in the workflow.

For an example of how to fill "Set a value", look at this table:

mceclip0.png

To cover this area, you must use A1:F8.

 

Sort by columns

  1. Set a value — allows you to manually specify the column indices by which you want to sort the range. For example, D,E. 
  2. Calculate a value — lets you use a special formula or method to set the column indices. 
  3. Save the previous step result — takes the column indices from the result of the previous step in the workflow.

 

Order by

Here you can choose the required option:

  • Ascending
  • Descending

 

Excel sheet name

  1. Set a value — allows you to manually specify the name of the sheet in which you want to perform actions.
  2. Calculate a value — allows you to use a special formula or a special method to determine the name of the Excel sheet.
  3. Save the previous step result — takes the Excel sheet name from the result of the previous step in the workflow.

 

Comment

Allows you to add explanatory text to the block. The text will be displayed inside the block on top of the activity name.

 

Related articles