Action group: Excel
The action deletes specified columns with a left shift.
Property | Description | Type | Filling example | Mandatory field |
Parameters | ||||
Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
Starting column name | The 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 index | The 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 name | The 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 index | The 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 |
None.
There is an Excel-document. Delete columns A, B, C.
Solution
Use the "Open", "Delete document", "Save", "Close" actions.
Implementation
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.
The specified columns are deleted.