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

Description

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.

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.
• NomFeuille : le nom de la feuille du classeur.

Options

• 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.

Utiliser le classeur

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

Activités connexes

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