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.

To change the name or value of an Active cell or a Specified cell in a Microsoft Excel spreadsheet or a CSV file in a row or a column, see Set cell.

To insert or delete rows or columns in a worksheet, do the following:

过程

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.
1. Select the Insert Row at option to insert a row and specify the location where you want to insert the row in the field.
2. 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 enter 1:5 in the field.
Select the Column operations if you want to insert or delete columns from the spreadsheet.
1. Select the Insert Column at option to insert a column and specify the location where you want to insert the column in the field.
2. 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 enter A:E in the field.
Enter the name of the session used to open the workbook with the Open action.
Click Save.