Description
This action allows you to overwrite data in a certain column of an 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 activity as the path.
Value
Calculate a value option allows you to specify the new data to be contained in the overwritten column. The data must be an array in JavaScript syntax. For example, if the data will be 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 option takes the result of the previous workflow activity as data. Note that in this case, the result of the previous activity must also be an array.
Column
Set a value - allows you to manually specify the index of the column where to overwrite the data. The index is indicated by the letter of the corresponding column, for example, A
.
Calculate a value - allows you to use a special formula or a special method to determine the column index.
Save the previous step result - takes the result of the previous workflow activity as the column index.
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 does not change the formatting of the Excel table.