Gallery - Input File - <List of Sheet Names>

[wolfgangh]

Hi all,

we created a workflow, that runs on the local machine. As soon as we run it on the server, we have a couple of different issues, that will disturb the user.

1. The input tool offers to choose the <List of Sheet Names>. It would be helpful to suppress the this selection

2. The Gallery gives feedback, that the result did not create results. That is not true, since the workflow creates files that are store on a share drive. Is there a way to adapt that? If I run the workflow on the local machine, I can at least see the file that was created.

Thanks for your help!

Best regards,

[fmvizcaino]

Hi @wolfgangh ,

For your 1st question, I don't think it is possible to remove the option to list sheet names.

For the 2nd one, I suggest you to insert a browse tool in paralel with your output data tool and to configure the interface designer as follows:

When checking the browse tool, your workflow will produce a view of your file in your gallery results.

Best,

Fernando Vizcaino

[DavidP]

For Question 1, perhaps you can try changing the file format (Option 2) to Microsoft Excel legacy (xlsx)  - this does not support list of sheet names. I have not tested how this looks on Server though.