The "Update cell value" instruction is used to manually input a value into a cell within an Excel spreadsheet. This value can either be static (i.e. set in advance when the process is built) or dynamic (i.e. linked to a data step property).
Creating the step
Firstly, create an action step to manipulate data and select "Update cell value" in the "Excel" section.
This instruction is quite simple to configure. You will need to:
- link to the relevant Excel workbook (stored in a data step property)
- the relevant worksheet
- the relevant cell range
The last step is dependent on whether the value to be updated is a static value that will be the same from run to run, or a dynamic value that is linked to a data step property.
If the value is the same from run to run, and is not expected to change, click on "Literal" and enter the relevant value in the box to the right.
You have the option to also specify the data type of this value, which will be recognised in Excel.
If the value is dependent on a data step property and is not expected to be the same from run to run, click on "Input/output of another step".
The following pop-up window will appear.
Here, you can navigate to your desired data step property.
You can indicate which process this data step property is located in the dropdown menu at the top. The default is the current process.
You can then navigate to the relevant step number on the left.
You can then finally find the relevant data step property belonging to this configuration on the right. Once you've selected the correct data step property, click on "Choose the selected property" on the bottom right to confirm your selection.
Since the data step property is currently set to the string "Test", this specific instruction will update the cell range to the string "Test".
Note: if you choose a cell range that includes more than one cell (for example, A1:C3), then all of these cells will contain this cell value.