Skip Ribbon Commands
Skip to main content
SharePoint

Populate Data Items with Excel Workbook Properties

To populate data items with excel workbook properties, 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 Workbook Properties tab. The corresponding screen is displayed.

  4. From the list of check boxes, select the workbook property you want to read. The corresponding field is enabled.

  5. In the selected field, click the Data Item editor icon. A drop-down list is displayed.

  6. Select the data item in which you want to store the property value.
      
    Note:
    Calculation data items are read-only. You cannot edit this type of data item.

     
    Note: 
    Repeat steps 4 to 6 to read other workbook properties.

      
  7. Click OK. You configured the activity to populate data item with InfoPath form date created value.
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
Read Values from a Password-protected Workbook and Worksheet

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