Skip Ribbon Commands
Skip to main content
SharePoint

Write Values to a Password-protected Workbook and Worksheet

To write values to a password-protected workbook and worksheet, complete the following steps:
  1. Check out and open the process you want to edit.

  2. Open the Write Excel Workbook activity that you previously configured and now want to edit. 

  3. Click the Input File Protection tab. The corresponding screen is displayed.

  4. Select the Password Required to Open the Workbook check box.

  5. In the Password Required to Open the Workbook field, select the appropriate input field editor and set the field to a value
    that is the password for opening the workbook.

  6. Select the Password Required to Open Worksheets check box.

  7. In the Worksheet field, select the appropriate input field editor and set the field to a value that is the name of the worksheet.

  8. In the Password field, select the appropriate input field editor and set the field to a value that is the password to read from worksheet.

  9. Click OK. You configured the activity to read values from a password-protected workbook and worksheet.
Related Topics
Update an Existing Excel Workbook with Data Item Values
Set Workbook Properties when Creating or Updating a Workbook
Protect a Workbook by Setting a Password to Open the Workbook
Protect a Worksheet by Setting a Password to Edit Worksheet Cells
Remove Protection from a Worksheet that Required a Password for Editing

Source
BPM Designer Topics > Overview of Activities and Activity Topics > Microsoft Office Activities > Write Excel Workbook
Last modified at 7/31/2020 12:13 PM