Skip to main content

Insert Column

UiPath.MicrosoftOffice365.Activities.Excel.InsertColumn

Description​

Uses the Microsoft Graph Create Column API to insert a new column in a table. The previous column at the indicated position is shifted to the right.

Scopes​

This activity requires the following scopes:

  • Files.ReadWrite

OR

  • Files.ReadWrite.All

OR

  • Sites.ReadWrite.All

Project compatibility​

Windows - Legacy | Windows

Configuration​

Properties

Common​

  • DisplayName - The display name of the activity. This property supports String variables and string formatted values.

Input​

  • Column Name - The name of the new column to insert. This property supports String variables and string formatted values.
  • Column Values - The values to add in the new column, specified as a DataTable containing only one column. This field supports only DataTable variables.
  • Position - The relative position of the new column. If left blank or if the value is greater than the index of the last column, the column is added to the end. If the value is less than 0, it is added to the front. This field supports only integer and Int32 variables.
  • Table Name - The name of the table. This property supports String variables and string formatted values.
  • Workbook - The Drive Item of the Excel document. Use the Find Files And Folders activity to retrieve this Drive Item. This field supports only DriveItem variables.

Misc​

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.