Delete Column

UiPath.MicrosoftOffice365.Activities.ExcelDeleteColumnConnections

Description

Delete a specified column from a sheet, table or range. The column on the right of the deleted column is shifted to the left.

Scopes

This activity requires the following scopes:

• Sites.ReadWrite.All

Project compatibility

Windows | Cross-platform

Configuration

• Microsoft OneDrive & SharePoint connection - The connection for the Microsoft 365 account to use in the activity.
• Workbook - The target workbook to delete columns from. The method to specify the file to be retrieved: Folder picker, Enter Id, Enter Url.

  • Workbook sample - The workbook template to use. The field is visible after clicking Use workbook template. Browse the OneDrive folders and select a workbook. In Studio Desktop, the option is available from the See more button menu next to Range type. To learn more, see Working with templates.

  • File/Folder picker option: Click the Folder icon to browse the OneDrive or SharePoint files/folders and select a spreadsheet. This option accepts input as IResource.

    • Use the See more button menu to use a variable or select the Reload Folder Data option if you've modified your folders and need to retrieve the latest data.

  • Enter Id option:

    • Workbook Id - The ID of the workbook of interest. This property supports String variables and string formatted values.
    • SharePoint site address - The URL of the SharePoint site that contains the file or folder. This property supports String variables and string formatted values. Open your SharePoint site in a browser and copy its URL, e.g., https://yourcompany.sharepoint.com/sites/ProductOfficial.
    • SharePoint document library - The document library within the indicated SharePoint site that contains the file or folder. This property supports String variables and string formatted values. Open the Documents tab in your SharePoint site and copy the URL, e.g., https://yourcompany.sharepoint.com/sites/ProductOfficial/Shared%20Documents/Forms/AllItems.aspx.

  • Enter Url option:

    • Workbook Url - The URL of the workbook of interest. This property supports String variables and string formatted values. Retrieve the URL by opening the file in a browser.
• Range - Indicates the range where to delete the column. You can write custom ranges using full A1 Notation, e.g., Sheet1C2:F10. This property supports String variables and string formatted values.
• Has headers - If selected, the column headers are generated by reading the range header. Boolean value. Default value is set to True.
• Column Name or Column Position - Specify a column or a column position to delete, e.g., "Transaction Date", "2". The first position is 0.
  • Update columns - Select this option if you've modified your sheet and need to retrieve the latest data.
• Delete behavior - Indicates the delete mode.
  • Clear contents - Clear contents of the selected column.
  • Delete - Delete the selected column and shift cells left.
    Note: If the Clear option is selected:

    • If Has Headers is True: clears the content and excludes the header.
    • If Has Headers is False: clears the entire column, including the header.

    If you want to remove the header as well, use the Delete option.

Output

• Range information - The updated range information, after the column is deleted, stored in a RangeInformation variable. Automatically generated output variable. You can use it as it is or save it with a different name.

Example

See also:

• Excel Online activities
• Create Workbook
• Read Range