Subscribe

UiPath StudioX

The UiPath StudioX Guide

Delete Column

UiPath.Excel.Activities.Business.DeleteColumnX

Deletes a specified column from a sheet, table or range in an Excel file.

In the Body of the Activity

  • Source range - Click plus button on the right side of the field, then, from the menu, select the file and then a sheet, table, or range from which to delete a column, or select Indicate in Excel to indicate a range directly from the file. Alternatively, you can select Custom Input to enter the range manually, or Open in Advanced Editor to enter a VB expression.
  • Has headers - If this option is selected, it indicates that the first row in the defined source range is a header row. When you then indicate the column to delete, the values in the column headers are displayed in Column name > Range, enabling you to easily identify the column. If this option is not selected, Column name > Range displays column letters when the source range is a sheet or a range, or header row values when the source range is a table.
  • Column name - Click plus button on the right side of the field, then, from the menu, select Range, and then the column to delete. Depending on your selections for Source range and Has headers, the columns can identified by the values in the first row of the selection or the letter of the column.

Properties

Common

  • Display Name - The name displayed for the activity in the Designer panel.

Input

Misc

  • Private - If selected, the data used in the activity is not logged by StudioX.

Options

Updated 3 years ago


Delete Column


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.