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

5 次查看（过去 30 天）
hxen
hxen 2023-6-2
评论： hxen 2023-6-2
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.

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2023-6-2
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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by