Hi,
I am using layout and render tool in my workflow and the output i am getting is the at the order of the sheets is in alphabetical order so can we customize the order of sheets.
can we get any solution for this.
@vijaylnyadav
So what kind of order you want? 😁
Hi @Qiu
i want a particular sheet on the first sheet say for eg. sheet name "zebra" i want this sheet name on the first sheet.
@vijaylnyadav Do you accept something like "0-Zebra"?😁
Hi @Qiu ,
Thanks for the suggestion but i want the exact name "Zebra" on the first tab on the output excel file because it is the requirement.
So I understand your requirement, but I am sorry I dont know how to do it.
If you are accepting plain Excel via Output Tool, I think we can do it, but not the Render tool.
First create a text input tool with the correct numbered order. Then join by position to the layout tool output. Then use a sort tool and sort by the correct order finally putting a render tool after. Then it writes using the correct order that you manually sorted to after the layout.
