Definition and Usage

The Write to Excel column command is used to write content column by column into an Excel worksheet. It supports appending, inserting or overwriting content.

Note: A Write to Excel column 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 Append (write on the next column after the last non-blank column), Insert (write before the target the column), Overwrite (overwrite the specified column).
Input mode	Specify the input mode as Write to a specific row Write to an entire column.
Start row number	Specify the starting row 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 default sheet. The value will be written to the file like this: