Write operation using Activexserver command
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Gopalakrishnan venkatesan
am 11 Mai 2015
Beantwortet: Thomas Koelen
am 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 Kommentare
Akzeptierte Antwort
Thomas Koelen
am 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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!