Insert Column
insert data into a column
Insert column data into the specified column of the sheet in the google sheets.
Input
Credential:
Object Variable
A variable name that references the user credential to access the resources.
SpreadSheet Id:
String Argument
The Id of the spreadsheet in which column data is to be inserted.
Sheet Name:
String Argument
The name of the sheet in which column data is to be inserted.
Starting Cell :
String Argument
The starting cell in which column data is to be inserted.
Column Data:
List of Object Variable
The column data is to be inserted.
Options
Insert Method: The method for inserting column values.
SHIFT
- shift column after inserting the column data when the column to be inserted contain values.REPLACE
- replace the column values with the column data if the specified column contains values.
Last updated