Outputting Multiple Excel Tabs

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.

Output

Accepted answers

JosephSerpis

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

OutputtoDifferentTabs.yxzp

All comments

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.

OutputtoDifferentTabs.yxmd

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.

Multipe_Excel.yxdb

Féilim

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703