Action groups: Office
Action deletes the specified columns
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with ods/xlsx table. | Robin.OpenSheetD oc | Yes | |
| Starting column name | The name of the starting column in the range of columns to be deleted. If the field is not filled in, the starting column will be determined by the value from the «Starting column index» field. If neither the name nor the index of the starting column is specified, the action will fail. | Robin.String | No | |
| Starting column index | The sequence number of the starting column in the range of columns to be deleted. The numbering starts from 1. | Robin.Numeric | No | |
| Ending column name | The name of the ending column in the range of columns to be deleted. If the field is not filled in, the starting column will be determined by the value from the «Ending column index» field. If neither the name nor the Ending column index is specified, the range will be limited to the starting column only. | Robin.String | No | |
| Ending column index | The sequence number of the ending column in the range of columns to be deleted. The numbering starts from 1. | Robin.Numeric | No | |
None.
There is a tabular document. It is necessary to delete columns A, B, C.
Implementation of the action requires the following actions - "Open", "Delete columns", "Save".
2. Set parameters for the "Open" action. In the "Path to file" field specify the path to the required tabular document.
3. Set the parameters for the "Delete columns" action.
4. Set the parameters of the "Save" action. In the "Context" field specify the context of the opened document "Test 1"
5. Launch the robot using the "Start" button in the top panel.
The program robot completed successfully.
The specified columns have been deleted.
