How to name an excel worksheet when using writetable

156 次查看（过去 30 天）
Stephen
Stephen 2017-7-21
评论： Walter Roberson 2022-7-9
Is there a simple way to name an the excel worksheet when using the writetable fnx? I am aware of the answer by Thomas Koelen on 8 May 2015 ( https://www.mathworks.com/matlabcentral/answers/215703-changing-the-name-of-the-sheet-in-excel ) but I am hoping there is a more direct and simple method, not involving ActiveX. Instead of an excel workbook with "Sheet1", "Sheet2", etc I want to give specific names to the worksheets.

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2017-7-21
writetable(TableObj,'test.xlsx','FileType','spreadsheet','Sheet','MyTable')
  8 个评论
显示 6更早的评论
Walter Roberson
Walter Roberson 2022-7-9
Hastyar Barvar:
The topic of the link is how to get rid of the default three sheets that are created, 'sheet1', 'sheet2', 'sheet3' . Deleting those sheets after creation is a valid approach to the question of how to end up with an Excel worksheet that does not have sheets with those names, which is what @Stephen was asking about.

请先登录，再进行评论。

更多回答（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