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
Concept | Description | Type | Required |
---|---|---|---|
table | The reference to the Excel table. | excel table reference | Yes |
index | The index at which to insert the new column. | number | Yes |
name | The name of the new column. | text | Yes |
values | The values to insert in the new column. | boolean or number or text | Yes |
Output Concepts
Concept | Description | Type |
---|---|---|
new column | None. | 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
Updated 6 days ago