Insert Column
insert data into a column
Last updated
insert data into a column
Last updated
Insert column data into the specified column of the sheet in the google sheets.
Credential: A variable name that references the user credential to access the resources.
SpreadSheet Id: The Id of the spreadsheet in which column data is to be inserted.
Sheet Name: The name of the sheet in which column data is to be inserted.
Starting Cell : The starting cell in which column data is to be inserted.
Column Data: The column data is to be inserted.
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.