How to name an excel worksheet when using writetable
125 次查看(过去 30 天)
显示 更早的评论
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.
0 个评论
采纳的回答
Fangjun Jiang
2017-7-21
writetable(TableObj,'test.xlsx','FileType','spreadsheet','Sheet','MyTable')
8 个评论
Walter Roberson
2022-7-9
Hastyar Barvar comments to @Seum Bin Rahman
irreverent and sensing for a downlink
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!