Desproteger hoja

UiPath.Excel.Activities.Business.UnprotectSheetX

Permite desproteger una hoja protegida en Excel para realizar cambios en ella. La actividad se puede utilizar con los archivos de Excel seleccionados para las actividades principales de Usar archivo de Excel o con el Cuaderno del proyecto.

Configurar la actividad

En el cuerpo de la actividad

• Sheet - Select Plus on the right side of the field, then select the sheet you want to unprotect.

• Password - Select Plus on the right side of the field, and then, from the menu, select one of the available options:

  • Data from the Project Notebook, a parent Excel file or Outlook account. For example, select an Excel file, and then select Indicate in Excel to indicate a cell from the file, or select an email in Outlook and then select a field in the email that contains the password.
  • Ask when run - Prompt for the password when the project is executed.
  • Paste from clipboard - Paste a value that you previously copied to the clipboard in the project.
  • Use Saved Value - Select a value that you previously saved for later use in the project.
  • Text - Enter the password using the Text Builder.
  • Open in Advanced Editor - Enter a VB expression.

• Toggle password mode - Alternatively, you can select the toggle password mode button and enter the password manually. Instead of entering passwords directly, we recommend storing passwords securely and retrieving them with an activity such as Get Username/Password.

Panel de propiedades

Común

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

Entrada

• Password - The password required to unprotect the sheet.
• Password (SecureString) - The password required to unprotect the sheet, as a SecureString type.
• Sheet - The sheet to be unprotected.

Otros

• Privado : si se selecciona, los valores de las variables y los argumentos ya no se registran en el nivel Detallado.