How to change excel sheet order

[henrygeorge]

Hi Alteryx Team,

I am currently using the block until done tool to place my output excel in 3 different sheets..however the sheet order is off when running. How do I solve the order of the sheets to be according to my fancy?

[LordNeilLord · Accepted solution]

Hey @henrygeorge 

I sometimes find adding additional tools to my workflow can better control the order in which the sheets get written....

[CharlieS]

If you are using the Render tool to output formatted Excel sheets, then the sheet order will be alphabetic according to sheet name. I typically recommend adding a sheet number prefix if a specific order is desired. 

[Jay_Clark]

I use a leading space to move " Summary" tab in front of the "Details" tab.  

[IvanFonseca]

Hi @CharlieS ,

Is this still the only solution to change orders of sheets in the render tool? by using a prefix?

Thanks!

[CharlieS]

---

@IvanFonseca wrote:

Hi @CharlieS ,

Is this still the only solution to change orders of sheets in the render tool? by using a prefix?

Thanks!

---

Yes. The rendered sheets will be string-sorted. I typically just number my sheets in the order I want.