Description
This activity allows you to insert a column at the end of the selected Excel document.
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 - allows you to manually specify the path to the target excel document. Click the "Select" button to open the file explorer and select the path.
Calculate a value - allows you to use a special formula or a special method to determine the path.
Save the previous step result - takes the result of the previous workflow action as the path.
Value
Calculate a value - allows you to specify the data that will be contained in the new column. The data must be an array in JavaScript syntax. For example, if the new column will contain a list of cities Moscow, New York, Istanbul, the data in the form of an array should look like this:
["Moscow","New York","Istanbul"]
Save the previous step result - takes the result of the previous workflow activity as data. Note that in this case the result of the previous action must also be an array.
Excel sheet name
Set a value - allows you to manually specify the name of the sheet in which you want to perform actions.
Calculate a value - allows you to use a special formula or a special method to determine the name of the Excel sheet.
Save the previous step result - Excel 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.
Note. This activity adds information to Excel without formatting.