How to name an excel worksheet when using writetable

235 views (last 30 days)
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.

Accepted Answer

Fangjun Jiang
Fangjun Jiang on 21 Jul 2017
writetable(TableObj,'test.xlsx','FileType','spreadsheet','Sheet','MyTable')
  8 Comments
Walter Roberson
Walter Roberson on 9 Jul 2022
Hastyar Barvar comments to @Seum Bin Rahman
irreverent and sensing for a downlink
Walter Roberson
Walter Roberson on 9 Jul 2022
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.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!