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

Output

Accepted answers

@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/488859

All comments

@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/488859

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15875

MarqueeCrew 13708

apathetichell 13703