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.
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.
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.
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.