Set column data Version 9 (.Net)

Action group: Excel 

Description

The action sequentially fills the column cells with values from the specified list, starting from a starting cell in the column.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
Column nameName of the column to which the action will be applied. If the field is not filled, then the value from the «Column index» field is taken.Robin.String
No
Column indexIndex of the column to which the action will be applied.Robin.Numeric
No
Range start line numberThe line number to which the action will be applied.Robin.Numeric
Yes
Cell valuesThe list of values that will be used to fill the cells in the column.Robin.Collection
Yes

Special conditions of use

"R1C1" link style is not supported.

Example of use

Task

There is an empty Excel-document. Set column data.

Solution

Use the "Open", "Set column data", "Save" actions.

Implementation

  1. Assemble a robot scheme with the actions.
  2. Set the "Open" action parameters.
  3. Set the "Set column data" action parameters.
  4. Set the "Save" action parameters.
  5. Click "Start" in the top panel.


Result

The program robot completed successfully.

The data was inserted in the column.