Select Excel sheet via dropdown

[Paul_s_Moody]

I have a workflow with an input file set to an Excel spreadsheet.

I'm trying to add functionality to a workflow whereby the user can select one of the various sheets from the spreadsheet to be used as a datatable within the workflow.

For example, my excel spreadsheet has 3 sheets (each with the same format) called:

• Male                   This is the default sheet currently read by the workflow
• Male_2011          This is an old version of the table as at 2011
• Male_1995         This is an (even) older version as at 1995

In certain circumstances, the workflow needs to look at an old version of the table rather than the current one.

I can change the sheet reference "manually" by selecting the "Table or Query" within the configuration window, but it would be easier fo users if they could use the dropdown to select the appropriae sheet.

Thanks,

Paul

[Clifford_Coon · Accepted solution]

Hi Paul,

You can do this using a chained app

1. First W/F in Chain - Derive sheet names and save in yxdb - name: value  format

2. Second W/F - use the yxdb from step 1 as the input to a Drop Down where the sheet is selected.

The interface tools are initiate at the beginning of each W/F so that's why I choose chained app to get around that limit.