How to insert multiple spreadsheets to a workbook from Matlab
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
wangm
le 29 Juil 2020
Modifié(e) : Walter Roberson
le 28 Sep 2020
Matlab provide a method to insert one spreadsheet: using the command
eNewSheet = Add(eSheets,[],eSheet1);
However, if I know I need to add multiple spreadsheets, e.g. 5, is there a way to tell Add comment, or I have to do a for loop to insert 5 sheets?
Thanks
0 commentaires
Réponse acceptée
Michael Croucher
le 28 Sep 2020
You can add the number of sheets as an extra argument. So, for 5 sheets:
eNewSheet = Add(eSheets,[],eSheet1,5);
1 commentaire
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Use COM Objects in MATLAB 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!