SetCellReference function

This function is used to set the value in a specified cell in the excel file.

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select SETCELLREFERENCE function. Provide file path, cell reference, value to be set and sheet number.

If the data is successfully set on the given cell reference, it will return true in a variable defined in the Element Key and after completing this step will look as below: