Definition and Usage
The Write to Excel row command is used to write content row by row into an Excel worksheet. It supports appending, inserting or overwriting content.
Note: A Write to Excel cell command must to used with a Launch Excel command.
Parameter Values
Set parameters
Parameter | Description |
Excel object | Select an Excel object. |
Write mode | Specify the write mode as
|
Input mode | Specify the input mode as
|
Start column | Specify the starting column to input the value. Enter a non-zero integer or a letter. 1 means the first column and -1 means the last column. |
Value to write | The content to write. |
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
Suppose we want to insert a 1-row, 2-column value to an Excel file. The value is like
Octoparse | RPA |
We need to create a data table variable as the value:
The workflow will be like this:
This workflow will open the Task.xls file and insert the value into the first row of the SheetA. The value will be written to the file like this:
