删除列

UiPath.Excel.Activities.Business.DeleteColumnX

描述

从 Excel 文件的工作表、表格或范围中删除一列或多列。该活动可以与为父级使用 Excel 文件活动选择的 Excel 文件一起使用，也可以与“项目笔记本”一起使用。

配置活动

设计器面板

删除单列

• Source - Select Plus 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 from the Column name field, the values in the column headers are displayed under Range, enabling you to identify the columns. If this option is not selected, the options displayed under Range are the column letters when the source range is a sheet or a range, or the header row values when the source range is a table.
• Column name - Select Plus 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 are identified by the values in the first row of the selection or the letter of the column.

删除多列

• “来源”- 选择包含要删除的列的工作表或范围。

  备注：

  表格不支持删除多个列。如果您选择一个表格作为源并选择多个要删除的列，则执行自动化时会发生错误。

• “含标头”- 确保未选择此选项。

• “列名称”- 输入要删除的列的字母，并用冒号 (:) 或逗号 (,) 分隔。

  例如，您可以在“文本生成器”输入以下内容：

  • “A:E”表示删除 A、B、C、D、E 列。
  • “A,B,E”表示删除 A、B、E 列。

属性面板

常见

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

输入

• 请在活动正文中查看选项。

其他

• 私有 - 选中后将不再以“Verbose”级别记录变量和参数的值。

选项

• “有标题” - 在活动主体中查看“有标题” 。