Write Value To Excel File Step

Brief description

This step writes the value to the defined Excel cell of a previously connected Excel file.

Step Information

Step name (Not required) – the custom name of the process step that labels the editor’s process step box

Input parameters

• Excel instance name (Required)– value of the unique connection instance name previously defined in the Open Excel File step
• Column index (Required if ‘Column name’ does not contain the value)– existing variable name or value that specifies the Excel column row
• Column name (Required if ‘Column index’ does not contain the value)– existing variable name or value that specifies the Excel column letter (A, B, C, ...)
• Row index (Required)– existing variable name or value that specifies the Excel row
• Sheet name (Required)– existing variable name or value that specifies the sheet name
• Value or variable reference to write (Required)– existing variable name that contains the value to write or entered value

Additional comments

The 'Excel instance name' text box contains the list of the instance names previously defined in the Open Excel File step/s.‘Column name’ and ‘Column index’ parameters cannot be used at the same time.