Write operation using Activexserver command
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Gopalakrishnan venkatesan
le 11 Mai 2015
Réponse apportée : Thomas Koelen
le 11 Mai 2015
I have 4 array, a = [1 2 3] b=[4 5 6] c=[8 9 10], text=[num1 num2 num3]
I need to write to excel sheet where a in sheet1, b in sheet2, c in sheet3 and i also should have header for three sheet as it is mentioned in text?
How can I do this?
Thanks a lot
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/150000/image.jpeg)
0 commentaires
Réponse acceptée
Thomas Koelen
le 11 Mai 2015
ws = wb.Worksheets.Item('sheetname');
Insert this before you put something in the sheet, that way it will in what sheet to put it. 'sheetname' is the name of the sheet you are trying to change, you can get these sheets with the xlsinfo command (or do it manually).
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from 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!