Delete rows Version 1 (Python)

Action group: Office

Description

Action deletes the specified rows

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with ods/xlsx table.Robin.OpenSheetD oc
Yes
Starting row indexThe sequence number of the starting row in the range of rows to be deleted. The numbering starts from 1.Robin.Numeric
Yes
Ending row indexThe sequence number of the ending row in the range of rows to be deleted. The numbering starts from 1.Robin.Numeric
No

Special conditions of use

None.

Example of use

Task

There is a tabular document. I need to delete rows 1 through 4

Solution 

Implementation of the action requires the following actions - "Open", "Delete rows", "Save". 

Implementation

  1. Assemble a robot scheme consisting of actions:

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 rows" action. 

    • In the "Context" field specify the context of the opened document "Test 1"
    • In the "Starting line index" field, specify the index of the start line in the range of lines to be deleted.
    • In the "Ending line index" field specify the index of the end line in the range of lines to be deleted.

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.


Result

The program robot completed successfully.


The required lines have been deleted


  • Нет меток