Skip Ribbon Commands
Skip to main content
SharePoint

Set Workbook Properties when Creating or Updating a Workbook

To set workbook properties when creating or updating a workbook, complete the following steps:
  1. Check out and open the process you want to edit.

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

  3. Click the Workbook Properties tab. The corresponding screen is displayed.

  4. Select the workbook property field you want to set. The corresponding field is enabled.

  5. In the selected field, select the appropriate input field editor and set the field to a value that corresponds to the selected field.

    Note:
    Repeat steps 4 and 5 to set other workbook properties.
     

  6. Click OK. You configured the activity to set workbook properties when creating or updating a workbook.
Related Topics
Create and Populate a New Excel Workbook with Data Item Values
Update an Existing Excel Workbook with Data Item Values
Write Values to a Password-protected Workbook and Worksheet
Protect a Workbook by Setting a Password to Open the Workbook
Protect a Worksheet by Setting a Password to Edit Worksheet Cells

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