Insert Cells
Description
This activity inserts a cell or a range of cells at the specified address inside the specified sheet.
This activity works only inside Google Context activity.
Properties
Insert - Specify one of the following options.
Option Description Single Insert a single cell at the specified address. A new cell will be inserted before the cell represented by the Cell Address property. Multiple Insert multiple cells at the specified address. The new cells will be inserted before the first cell represented by the From address. The number of cells to insert would be calculated based on the specified From and To addresses. Cell Address - Specify the address of the cell.
From - Specify the starting address of the Range. The address can be a cell address. It is a mandatory field if Multiple Cells is selected.
To - Specify the ending address of the Range. The address can be a cell address. It is a mandatory field if Multiple Cells is selected.
Location
- Spreadsheet Path / Id - Specify the relative spreadsheet path or Id inside Google Drive.
Misc
- DisplayName – Add a display name to your activity.
- Private – Logs the variable and argument values at the Verbose level when unchecked.
Optional
Sheet Name - Specify the sheet's name where you want to insert cells. By default, it operates on the currently active sheet.
Shift Cells - Specify the method for shifting the existing cells after inserting new cells. You have the following options:
Shift Option Description Down Shift the existing cells downwards. This is the default option. Right Shift the existing cells to the right Continue On Error – Specifies if the automation should continue even when the Activity throws an error. This field only supports Boolean values (True, False). The default value is False.
noteCatches no error if this Activity is present inside the Try-Catch block and the value of this property is True.
Output
- Range - Returns the inserted cell range address.
Example
Download Example