Get Excel File

The Get Excel file activity allows you to extract data when working with Microsoft Excel tables.

Activity settings

To open the settings window, click on the activity on the process diagram.

Parameters Tab

The Parameters tab displays the basic activity parameters.

extract-excel-file-1

Name. The activity name on the process diagram. It is set by the template when adding the activity. You can change the name if you need.

Parameter. A context variable that will store data from an Excel table. You can select it from the list or add a new one by clicking the add-button button. This field supports only the String type variables. For more information about context variables, see Process context.

Path to Excel file. The Excel file location in the file system. When specifying the path, you can use process context variables that store the path or a part of the path. Click on the specify-variable-icon icon and specify the variable. You can select it from the list or add the new one by clicking Create parameter. This field supports only the String type variables. The value is inserted as {$variable name}. You can fill in the field manually following this format.

Get sheet by. Select how to specify the sheet in the Excel file that you want to extract data from:

  • Number. In the Sheet number field, specify the number of the sheet in the Excel file;
  • Name. In the Sheet name field, specify the name of the sheet in the Excel file.

Table range. Specify the cell range in an Excel table that you want to extract data from. For example, A1:C7.

When you indicate the number, the sheet name, or the cell range, you can use values of the context variables. Click on the specify-variable-icon icon and specify the variable. You can select it from the list or add a new one by clicking Create parameter. This field supports only the String type variables. The value is inserted as {$variable name}. You can fill in the field manually following this format.

Headings. Here you can specify that the first row of an Excel table contains headings.

Conditions Tab

For more information about the Conditions tab, see Basic activity settings principles.

Found a typo? Highlight the text, press ctrl + enter and notify us