Mathworks does not offer any way to do this.
This question was recently explored in the context of someone who was providing sheet names, and was ending up with 3 extra sheets with default names. Someone (dbp I think it was) indicated that when Excel is asked to create a workbook, that it automatically adds the first sheet, and so for compatibility with Excel the first useless sheet is generated. We did not, however, see any good reason for the code to automatically generate sheet2 and sheet3.
1 Comment
Veronique Lago (view profile)
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/461877-how-to-delete-default-excel-sheets-when-using-writetable-function-mac#comment_744679
Sign in to comment.