Description
This activity allows you to read data from a selected column in an Excel document and save it to a variable.
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
- Set a value option allows you to manually specify the path to the target excel document. Click the "PICK" button to open the file explorer and select the path.
- Calculate a value option allows you to use a special formula or a special method to determine the path.
- Save the previous step result option takes the result of the previous workflow action as the path.
Column
- Set a value option allows you to manually specify the index of the column to read the data. The index is indicated by the letter of the corresponding column, for example, A.
- Calculate a value option allows you to use a special formula or a special method to determine the column index.
- Save the previous step result option takes the result of the previous workflow activity as the column index.
Excel sheet name
- Set a value option allows you to manually specify the name of the sheet in which you want to perform actions.
- Calculate a value option allows you to use a special formula or a special method to determine the name of the Excel sheet.
- Save the previous step result option takes the result of the previous workflow activity as the sheet name.
Comment
Allows you to add explanatory text to the block. The text will be displayed inside the block on top of the activity name.