> For the complete documentation index, see [llms.txt](https://docs.visualyze.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.visualyze.ai/integrations/office-365/activities/excel/insert-column.md).

# Insert Column

Inserts a new column to the table.

This activity inserts a new column to the user-specified table in the given workbook using the Microsoft Graph [Create Column](https://docs.microsoft.com/en-us/graph/api/table-post-columns?view=graph-rest-1.0\&tabs=http) API.

### Input

* **Connection Id:** [`GraphServiceClient Variable`](/getting-started/rpa-studio/variables.md#graphserviceclient) <mark style="color:red;">`Required`</mark>\
  Specifies the office 365 connection id.
* **Table Name:** [`String Argument`](/getting-started/rpa-studio/arguments.md#string)  <mark style="color:red;">`Required`</mark>\
  Specifies the name of the table in which the column is to be inserted.
* **Column Name:** [`String Argument`](/getting-started/rpa-studio/arguments.md#string)  <mark style="color:red;">`Required`</mark>\
  Specifies the name of the column to insert the column.
* **Workbook:** [`Object Argument`](/getting-started/rpa-studio/arguments.md#types-of-arguments)  <mark style="color:red;">`Required`</mark>\
  Specifies the [DriveItem ](https://docs.microsoft.com/en-us/graph/api/resources/driveitem?view=graph-rest-1.0)of the Excel workbook that contains the table in which the specified column is to be inserted. We can also specify the output variable of the [Find Files And Folders](/integrations/office-365/activities/files/find-files-and-folders.md) activity (which is **First** or **Results**) directly as input in this property or use the output variable of the [Create Workbook](/integrations/office-365/activities/excel/create-workbook.md) activity (**Workbook**). If we are using the **Results** property of the **Find Files And Folders** activity then we can directly specify the element in the array.\
  For example : Results\[1].
* **Position:** [`Object Argument`](/getting-started/rpa-studio/arguments.md#string)\
  Specifies the relative position of the new column. If the field is left **blank** or if the specified value is greater than the index of the last column, the new column is added to the end and if the specified value is 0 then the column is added to the front.
* **Column Values:** [`DataTable Variable`](/getting-started/rpa-studio/variables.md#datatable) <mark style="color:red;">`Required`</mark>\
  Specifies the values that are to be added in the new column as a **DataTable** containing a single column.