Hello everyone. I just posted another question that relates to this question as well, but I figured it would be best to split them up as they are asking specifically different things.
Anyways: Does anyone know if it's possible to Create a new sheet in an Excel file using the Output data option, but also to control the order of where the sheet is created within the Excel file?
Example: if I wanted to output to the tab "c:\alteryxTemporary\MyExcelfile.xlsx|Summary" however I always wanted that tab to show up first?
One way I would do this would be to simply create a template file that has the hard-coded tab order already established, and then simply overwrite the tabs as the code ran.... I am just looking for a different way to handle this without having to have a pre-created Excel file :-)
Thanks!
