Definition and Usage
The Write to Excel cell command is used to write specific values into a target cell on an Excel sheet. It allows you to update the Excel cell content easily.
Note: A Write to Excel cell command must to used with a Launch Excel command.
Parameters Values
Set parameters
Parameter | Description |
Excel object | Select an Excel object. |
Row number | Specify the row of the target cell. Enter a non-zero integer or a letter. 1 means the first row and -1 means the last row. |
Column number | Specify the column of the target cell. Enter a non-zero integer or a letter. 1 means the first column and -1 means the last column. |
Cell value | Enter the value that you want to write to the target cell. |
Sheet name (optional) | Enter the name of the worksheet. If empty, the current active sheet will be selected. |
Error handling
Parameter | Description |
When error occurs | Specify the action to proceed when an error occurs |
Example
This workflow will open the Task.xls file and write Octoparse
in the A1 cell in SheetA
of the file.