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!