How to name an excel worksheet when using writetable
156 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Stephen
le 21 Juil 2017
Commenté : Walter Roberson
le 9 Juil 2022
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 commentaires
Réponse acceptée
Fangjun Jiang
le 21 Juil 2017
writetable(TableObj,'test.xlsx','FileType','spreadsheet','Sheet','MyTable')
8 commentaires
Walter Roberson
le 9 Juil 2022
Hastyar Barvar comments to @Seum Bin Rahman
irreverent and sensing for a downlink
Walter Roberson
le 9 Juil 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.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!