Workflow Outputting multiple excel files off the server

Question

I have a workflow that creates multiple excel workbook, is there away to make it so all the sheets download off the server as you can when you output one excel workbook as shown in the attached image. Right now when we try to have multiple outputs in the workflow it does not give us this option on the server.

server download.PNG

MatthewO · Accepted Answer

Hello @Inactive User:

In the Output Data tool you can check the Take the File/Table Name From Field option in the Configuration pane and then map the field containing the sheet name: A, B, C, or D. The records will be written to the corresponding sheet in the Excel file.

Attached is a simple workflow that illustrates the configuration.

MatthewO · Accepted Answer

@Inactive User the process will be the same. Two modifications to the workflow can achieve this result.

In the Formula tool, the full file path and sheet name are specified. The example below writes everything to "Sheet1" but the sheet name could be generated based on a formula or field as well.

In the Output Data tool, change the action to "Change Entire File Path"

This will render the results to different files that can be downloaded.