Outputting Multiple Excel Tabs

[Féilim]

Hi All, 

I have been able to get multiple tabs to generate in the one Excel file using Block Until Done, see below section of workflow (unfortunately can't share file). I have about 24 tabs generating, and will be using the workflow multiple times with different raw data and as such would like to be able to do two things:

- when choosing output file path, would it be possible to select this once, as currently I having to do it 24 times; and

- sort the order of the tabs being outputted.

Any help with either issue would be appreciated,

Féilim.

[JosephSerpis]

Hi @Féilim if you built you filepath or filename before the output you could use "Take file/table name from field at the bottom of the output saying you having to create an output for every scenerio.

[Féilim]

Thanks @JS420. Would I be correct in saying that this would be pulling in the output file name from the data then in order to create it?

I have tried doing the below but get a "specify sheet name" error.

Would be very grateful if you could update the attached to reflect your method, so I can get a better look and replicate for my own workflow.

[wdavis]

Hi @Féilim,

The error is occurring because the in your SheetName field, the data is the same in every row "Sheet". For this to work, it requires a unique sheet name each time. For example, if in your example workflow you change the field to be FieldName, this would then export correctly.

Kind Regards

Will

[JosephSerpis]

Hi @Féilim  I have mocked something up for it does use a batch macro have tried to comment to explain what I am doing. Please let me know if you have any issues.

[Féilim]

Sorry JS420 but it was more the Workflow I was looking for, would you be able to supply? Please. 

[JosephSerpis · Accepted solution]

Hi @Féilim Apologies have attached a packed workflow to this post.

[Féilim]

Thanks JS420.