Delete Sheet Workbook (preview)

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

UiPath.Excel.Activities.DeleteSheet

Beschreibung

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

Hinweis:

This activity does not support .xls files.

Projektkompatibilität

Windows | Plattformübergreifend

Eigenschaften

Allgemein

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

Eingabe

• Datei – Der vollständige Pfad der Ressourcenarbeitsmappe. Um zu einem lokalen Pfad zu wechseln, wählen Sie das Plus-Symbol und dann Lokale Datei verwenden aus. Das aktuelle Feld ändert sich zu Datei (lokaler Pfad), wo Sie den vollständigen Pfad der Arbeitsmappe angeben können.
• Sheet Name - The name of the sheet to delete. This field is required.

Optionen

• Kennwort – Das Kennwort der Arbeitsmappe, falls erforderlich

Verwenden der Arbeitsmappe

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

Hinweise

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.