BPM5 Documentation - Automatically Populate Data Item Values with Excel Worksheet Row Values

To automatically populate data item values with Excel worksheet row values, complete the following steps:

Check out and open the process you want to edit.
In the Toolbox pane, click Microsoft Office. A list of activities is displayed.
Double-click or drag the Read Excel Workbook activity into the process.
Link the activity appropriately with other activities in the process.
Right-click the Read Excel Workbook activity. A shortcut menu is displayed.
Select View Properties. The Read Excel Workbook window is displayed.
Click the Input File tab. The corresponding screen is displayed.
In the Input File Location field, select the appropriate input field editor and set the field to a value that is a location where
the workbook to be read is stored.

Note:

If your input template is referenced by a data item, click Configuration values and enter a valid connection string for design-time, configuration purposes.

In the Authentication section, select Run as BPM Server or Specify credentials.

Note:

If you select Run as BPM Server, access will be granted or rejected based on the BPM Server credentials.
If you select Specify credentials, complete the Username, Password, and Include domain fields using the appropriate input field editors. The Include domain check box is optional and requires you to select the domain name, if selected.

Click the Data Mappings tab. The corresponding screen is displayed.
Select the Automatically Map Workbook Contents to Data Item Values check box.

Note:

If the Manually Map Form Control Values to Data Items check box is also selected, then those mappings will override any automatic mappings that the Process Engine finds.
In the Worksheet name field, select the select the appropriate input field editor and set the field to a value that is the name of the worksheet to be read.
From the Direction to read values options, select Read by row.

Note:

To store multiple row values to a collection data item, select the Select Collection Data Item Member for Mapping check box.
Complete the following:

a. In the Data Item name row field, select the appropriate input field editor and set the field to a value that is the name of the row that will contain the data item name.
b. In the Value row field, select the appropriate input field editor and set the field to a value that is row name that will contain the values to copy into the data item.
c. In the Start column field, select the appropriate input field editor and set the field to a value that is the column name from where the values will be copied.

Note:

Calculation data items are read-only. You cannot edit this type of data item.

Note:

Selecting the End column check box is optional. If selected you must set the field to a value that is the letter of the column where the copying of values ends.
Click OK. You configured the activity to automatically populate data item values with Excel worksheet row values.

Source
BPM Designer Topics > Overview of Activities and Activity Topics > Microsoft Office Activities > Read Excel Workbook

Last modified at 7/31/2020 11:19 AM

Automatically Populate Data Item Values with Excel Worksheet Row Values // <![CDATA[ _spBodyOnLoadFunctionNames.push("setupPageDescriptionCallout"); // ]]>

Automatically Populate Data Item Values with Excel Worksheet Row Values