Skip Ribbon Commands
Skip to main content
SharePoint

Read Values from a Password-protected Workbook and Worksheet

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

  2. Open the Read 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.

    Note:
    If you select a document template as the input file location in the Input File tab, you won’t be able to select this check box.


  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
Automatically Populate Data Item Values with Excel Worksheet Column Values
Automatically Populate Data Item Values with Excel Worksheet Row Values
Manually Determine which Data Item Values to Populate with Excel Worksheet Column Values
Manually Determine which Data Item Values to Populate with Excel Worksheet Row Values
Populate Data Items with Excel Workbook Properties

Source
BPM Designer Topics > Overview of Activities and Activity Topics > Microsoft Office Activities > Read Excel Workbook
Last modified at 7/31/2020 11:52 AM