Hey everybody!
Would someone in here be able to tell me how excel/dynamo comes up with the order of the sheets in excel? I have made a script where data on many different elements gets exported to the same file, but also a “List.Join”. I want the data from the “List.Join” to be the first sheet in excel since it is my “Overview” sheet. I hope it makes sense…
Excel data follows a singular structured format: an @L3 list where the top-level list represents the sheet, the sublists represent the rows, and the items in the sublists represent the cells (column values) in each respective row. This means that the writing to multiple sheets requires an @L4 list where you have a list of the above @L3 structures - one for each sheet.
Setup each dataset so you could write to a single sheet and then create a list of all datasets and a list of all sheet names. You’re literally just making a list of all the expected structures.
I have this setup for many different categories such as doors, windows etc. In the “Missing Export” is the data which i want to place in different sheets. In the “Overview” is the mixed overview of all the elements, but i want the “Overview” sheet to be the first sheet in the list. Which nodes would you use to go from the export and list.join note to something that fixes my problem? 
