Using Insert or Delete actions for rows and columns
Use the Insert or Delete actions to create or remove rows or columns from the current worksheet or CSV file.
Procedure
- Double-click or drag the Insert or Delete action from the Excel node in the Actions palette.
-
Select the Row operations if you want to insert or
delete rows from the spreadsheet.
- Select the Insert Row at option to insert a row and specify the location where you want to insert the row in the field.
-
Select the Delete Row(s) at option to delete
rows. You must specify the row number you want to delete in the field.
For example, if you want to delete the tenth row in the worksheet, you
must enter
10
in the field. If you want to delete the first five rows, you must enter1:5
in the field.
-
Select the Column operations if you want to insert or
delete columns from the spreadsheet.
- Select the Insert Column at option to insert a column and specify the location where you want to insert the column in the field.
-
Select the Delete Column(s) at option to delete
columns. You must specify the address of the column you want to delete
in the field. For example, if you want to delete column 'D' in the
worksheet, you must enter
D
in the field. If you want to delete the first five columns, you must enterA:E
in the field.
- Enter the name of the session used to open the workbook with the Open action.
- Click Save.