Insert a New Column in the Table

Insert a new column in the table of an Excel sheet.

📘

Note: This operation is part of the Excel Book (BDK). To use this book, you need to first learn it in your agent.

Input Concepts

ConceptDescriptionTypeRequired
tableThe reference to the Excel table.excel table referenceYes
indexThe index at which to insert the new column.numberYes
nameThe name of the new column.textYes
valuesThe values to insert in the new column.boolean or number or textYes

Output Concepts

ConceptDescriptionType
new columnNone.excel column reference

Examples

Insert a new column in the table of an Excel sheet.

get the first table
use the above as the table
insert a new column in the table
	the index is 1
	the name is "Column1"
	the values are "value1", 2, 3.0, True