can you specify a newly created sheet to be at the start of a spreadsheet using writetable?
9 views (last 30 days)
Show older comments
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.
0 Comments
Accepted Answer
Walter Roberson
on 2 Jun 2023
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
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!