插入工作表

UiPath.Excel.Activities.Business.InsertSheetX

描述

在 Excel 文件中插入工作表。该活动可以与为父级使用 Excel 文件活动选择的 Excel 文件一起使用，也可以与“项目笔记本”一起使用。

配置活动

设计器面板

• Create in workbook - Select Plus on the right side of the field and then, from the menu, select the file where to insert the sheet. Alternatively, you can select Open in Advanced Editor and enter a VB expression.

• Sheet name - Select Plus on the right side of the field, and then use one of the available options in the menu to indicate the sheet name:

  • 项目笔记本、父级 Excel 文件或 Outlook 帐户中的数据。例如，选择 Excel 文件中的一个单元格或所选 Outlook 电子邮件中的一个字段。
  • Use Saved Value - Select a value that you previously saved for later use in the project.
  • Text - Enter a name in the Text Builder.
  • “运行时询问”- 执行项目时提示输入名称。
  • Open in Advanced Editor - Enter a VB expression.

• Reference new sheet as - Optionally, if you want to reference the sheet in other activities, select Plus on the right side of the field, and then select Save for Later Use. You can reference the sheet in Excel activities fields that accept a sheet selection using the name of the saved value. This can be useful when you are working with an Excel file that does not exist at design time and you want to use the inserted sheet in other activities. In addition, you can also use the saved value to enter the sheet name in any activity field that accepts text input.

属性面板

常见

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

输入

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

其他

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

输出

• 请在活动主体中查看将新工作表引用为。