How to write new sheet to front of old Excel file

Help
1

Hey everyone,

Currently writing a new ‘totals’ sheet, I have created it from a dt extracted from an existing excel sheet. When I write it back into the file it is always appended to the end. Is there a way of making this a front sheet? (i.e before the other sheets in the Excel file).

Any help appreciated!

Dom

2

Hello @domluke90

If the name first sheet is “Sheet1”, you can write with another name and it will be the first.