New excel tab as first / Tab order in the Excel file

[Mateusz_Pietrzak]

Hi All,

I have a workflow which as an output is adding new tab to the existing excel file. I was asked to setup a tool in order to create a new tab as a first in the Excel file.
Could you please let me know if this is possible to set up in Alteryx? 

Based on my knowledge I think it is not possible within Alteryx. And if I am right, do you have any idea how it could be done? Should I create some kind of scrypt or VBA macro? 

Thank you in advance.

KR

Matt

[Qiu · Accepted solution]

@Mateusz_Pietrzak 
If you are ok with bring the content of existing excel file and output together with your content, below should work.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-change-excel-sheet-order/td-p/4...

[Emmanuel_G]

Hi @Mateusz_Pietrzak ,

Did you test it with Block until done tool ?

It can allow you to edit the order in which you want your excel file outputs to be done depending on how you link the outputs to anchors 1,2 and 3.

[Mateusz_Pietrzak]

Thanks Qiu, your advice worked as the charm for my case :)