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.

Remarque :

This activity does not support .xls files.

Compatibilité du projet

Windows | Multiplate-forme

Propriétés

Commun

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

Entrée

• Fichier - Chemin complet du classeur de ressources. Pour passer à un chemin local, sélectionnez l’icône plus, puis Utiliser le fichier local. Le champ actuel est remplacé par Fichier (chemin local), où vous pouvez fournir le chemin complet du classeur.
• Sheet Name - The name of the sheet to delete. This field is required.

Options

• Mot de passe : le mot de passe du classeur, si nécessaire.

Utiliser le classeur

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

Remarques

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.