Protect Sheet Workbook (preview)

Protect Sheet Workbook activity that protects a sheet in an Excel workbook, optionally allowing a set of actions while the sheet is protected.

UiPath.Excel.Activities.ProtectSheet

Beschreibung

Protects a sheet in an Excel workbook, optionally allowing a set of actions while the sheet is protected. This is the cross-platform equivalent of the Protect 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.
• Blattname – Der Name des Blatts aus der Arbeitsmappe.

Optionen

• Protection Password - The password that protects the sheet and that is required to unprotect it. If you don't set a password, the sheet is protected without one. This is different from Password, which opens the workbook file.
• Allowed Permissions - The actions that remain allowed while the sheet is protected. The default value is None. You can combine several values, for example, AllowSorting Or AllowFiltering. You can choose from the following permissions. The name in parentheses is the value to use in an expression:
  • Delete columns (AllowDeletingColumns)
  • Delete rows (AllowDeletingRows)
  • Filter (AllowFiltering)
  • Format cells (AllowFormattingCells)
  • Format columns (AllowFormattingColumns)
  • Format rows (AllowFormattingRows)
  • Insert columns (AllowInsertingColumns)
  • Insert hyperlinks (AllowInsertingHyperlinks)
  • Insert rows (AllowInsertingRows)
  • Sort (AllowSorting)
  • Use pivot tables (AllowUsingPivotTables)
  • Edit objects (DrawingObjects)
  • Edit scenarios (Scenarios)
• Password - The password of the workbook file, if necessary. It is not related to the protection of the sheet.

Verwenden der Arbeitsmappe

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

Zugehörige Aktivitäten

• Unprotect Sheet Workbook - Removes the protection from a sheet.