Delete Sheet Workbook (preview)

Delete Sheet Workbook activity that deletes a sheet from an Excel workbook.

UiPath.Excel.Activities.DeleteSheet

Description

Deletes a sheet from an Excel workbook. This is the cross-platform equivalent of the Delete Sheet Windows activity.

Observação:

This activity does not support .xls files.

Compatibilidade do projeto

Windows | Multiplataforma

Propriedades

Comum

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

Entrada

• Arquivo - O caminho completo da pasta de trabalho do recurso. Para alternar para um caminho local, selecione o ícone de mais e, em seguida, Usar arquivo local. O campo atual muda para File (caminho local), onde você pode fornecer o caminho completo da pasta de trabalho.
• Sheet Name - The name of the sheet to delete. This field is required.

Opções

• Senha - A senha da pasta de trabalho, se necessário.

Usar pasta de trabalho

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

Observações

The activity fails with an error in the following cases:

• The sheet does not exist.
• The sheet is the only sheet in the workbook. A workbook must always have at least one sheet.
• Deleting the sheet would leave the workbook without a visible sheet, for example, when you delete the last visible sheet and all the other sheets are hidden. Excel cannot open a workbook that has no visible sheet.