Insert Sheet Workbook (preview)

Insert Sheet Workbook activity that inserts a new sheet into an Excel workbook, optionally at a specific position.

UiPath.Excel.Activities.InsertSheet

描述

Inserts a new sheet into an Excel workbook, optionally at a specific position. This is the cross-platform equivalent of the Insert Sheet Windows activity.

备注：

This activity does not support .xls files.

项目兼容性

Windows | 跨平台

属性

常见

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

输入

• 文件- 资源工作簿的完整路径。要切换到本地路径，请选择加号图标，然后选择使用本地文件。当前字段更改为文件（本地路径） ，您可以在其中提供 workbook 的完整路径。
• New Sheet Name - The name of the sheet to create. This field is required.

选项

• Position - The 1-based position at which to insert the new sheet. The value must be at least 1. A value greater than the number of sheets adds the sheet at the end. If you don't specify a position, the sheet is added at the end.
• 密码- workbook 的密码（如有必要）。

使用 workbook

• Workbook - The existing workbook to use instead of a file path.

注意

• This activity has no SheetName property, because it creates the sheet itself instead of acting on an existing sheet.
• The activity fails with an error if a sheet with the same name already exists, if New Sheet Name is empty, or if Position is less than 1.