BPM5 Documentation - Manually Determine which Worksheet Cells to Populate with Values

To manually determine which worksheet cells to populate with workbook values, complete the following steps:

Check out and open the process you want to edit.
Open the Write Excel Workbook activity that you previously configured and now want to edit.
Click the Data Mappings tab. The corresponding screen is displayed.

Select the Manually Map Data Items to Cell Values check box.

Note:

To write a collection data item to multiple cells, select the Select Collection Data Item Member for Mapping and Multiple Row/Column Context check box and select a collection data item in the respective field.

In the Direction to populate multiple values section, select All data item values will be in the same column or All data item values will be in the same row.
In the Destination worksheet field, select the appropriate input field editor and set the field to a value that is the name of the worksheet which you want to populate.
In the Destination cell field, select the appropriate input field editor and set the field to a value that is the default cell name or label.
In the Value field, select the appropriate input field editor and set the field to a value that you want to write to the Excel worksheet.

Note:

You can map more values with data items by clicking the plus sign (+). Use the minus sign (−) to remove a mapping.
Click the Workbook Destination tab. The corresponding screen is displayed.
In the Output File Name field, select the appropriate input field editor and set the field to a value that is file name.

From the If the file already exists section, select Overwrite the file or Increment the file name.

Note:

Select Overwrite the file to replace the existing file. Select Increment the file name to append a _1, for example, to the file name the first time the process runs and sees that a file already exists. The number will increment each time the process runs and finds a file with the same name.

In the Output File Location field, select the appropriate input field editor and set the field to a value that is a file location where you want to store the new Excel file. The location must be accessible by the Process Engine.

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.

Click OK. You configured the activity to manually determine which worksheet cells to populate with workbook values.

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

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

Manually Determine which Worksheet Cells to Populate with Values // <![CDATA[ _spBodyOnLoadFunctionNames.push("setupPageDescriptionCallout"); // ]]>

Manually Determine which Worksheet Cells to Populate with Values