can you specify a newly created sheet to be at the start of a spreadsheet using writetable?

To put this in context: I have a large list of raw data for a series of individual measures. These data for each separate measurements are saved in individual sheets using writetable. I find any newly created sheet is put last in the spreadsheet but I would like to specify for a new sheet containing the summary of all the individual measurements (e.g. std, mean, etc) to be in located in the very first tab. I often have to update the data and the summary sheet is way to the back.

An obvious alternative is to manually relocated or just have a separate spreadsheet for the summary, but would like to have all in one excel file and this done automatically. Is this possible with writetable?

Thanks,

H.

Answer 1

[Walter Roberson]

no, writetable cannot manipulate the tab order.

If you happen to be using Windows see https://www.mathworks.com/matlabcentral/answers/479882-how-can-i-move-excel-sheets-in-the-same-file#answer_391418

[hxen]

Thank you Walter! Much appreciated.