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

Descripción

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.

Nota:

This activity does not support .xls files.

Compatibilidad de proyectos

Windows | Multiplataforma

Propiedades

Común

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

Entrada

• Archivo : la ruta completa del libro de recursos. Para cambiar a una ruta local, selecciona el icono más y luego Usar archivo local. El campo actual cambia a Archivo (ruta local), donde puedes proporcionar la ruta completa del libro.
• NombreDeLaHoja : el nombre de la hoja del libro.

Opciones

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

Utilizar libro

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

Actividades relacionadas

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