I want to store two worksheets together in excel sheet from matlab.
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
please help as I am only able to store only one worksheet at a time.
0 Kommentare
Antworten (1)
Azzi Abdelmalek
am 21 Nov. 2012
a=rand(5)
b=rand(5)
xlswrite('filename.xls',a,'sh1')
xlswrite('filename.xls',b,'sh2')
4 Kommentare
Azzi Abdelmalek
am 26 Nov. 2012
Bearbeitet: Azzi Abdelmalek
am 26 Nov. 2012
You din'nt mention the sizes of your variables (number of lines and column of each variable). If your variables have the same number of lines you can concatenate them for example:
var1=rand(10,2);
var3=rand(10,4);
var3=rand(10,5;
data=[var1 var2 var3]
xlswrite('filename.xls',data)
If not, tell us what kind of data are you using?
Siehe auch
Kategorien
Mehr zu Spreadsheets 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!