Delete column Version 9 (.Net)

Action group: Excel 

Description

The action deletes specified columns with a left shift.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
Starting column nameThe name of the starting column in the range to be deleted. If the specified column is not hidden, the action will display a warning. It will not terminate with an error. If the field is not filled, then the value from the «Starting column index» field is taken.Robin.String
No
Starting column indexThe index of the starting column in the range to be deleted. If the specified column is not hidden, the action will display a warning. It will not terminate with an error.Robin.Numeric
No
Final column nameThe name of the end column in the range to be deleted. If the field is not filled, then the value from the «Final column index» field is taken.Robin.String
No
Final column indexThe index of the end column in the range to be deleted. If the field is not filled, then a single column will be deleted.Robin.Numeric
No

Special conditions of use

None.

Example of use

Task

There is an Excel-document. Delete columns A, B, C.

Solution

Use the "Open", "Delete document", "Save", "Close" actions.

Implementation

  1. Assemble a robot scheme with the actions.

 

2. Set the "Open" action parameters.

3. Set the "Delete column" action parameters.

4. Set the "Save" action parameters.

5. Set the "Close" action parameters.

6. Click "Start" and see the result.

Result

The specified columns are deleted.

  • Нет меток