Additional actions and features
You can use the Get First Free Row on Column from Excel Worksheet action when you want to write data to the first available cell in a given column.
The Read and Write actions can use the currently selected cell as a point of reference. The Get Selected Cell Range from Excel Worksheet action is used for this purpose by providing the indexes of the first and last column and row of the selection.
To change the selected cells, use the Select Cells in Excel Worksheet action. Set the Select option to Range of Cells to select cells by specifying the upper-left and bottom-right corner cells.
Or you can set the Select option to Range of Cells Relatively to Active Cell to select a number of cells from the currently selected cell.
To activate a particular cell, use the Activate Cell in Excel Worksheet action. In the Activate field, you can either choose to specify a cell by its coordinates (Absolutely specified Cell) or relative to the currently active cell (Relatively specified Cell).
You can also insert and delete columns and rows by using the appropriate actions, but you are required to specify a column or row index. With insertion, the row or column is added before the one that is specified.
Need help? See our troubleshooting guide or provide specific feedback by reporting an issue.