writing data to excel files
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Inti Vanmechelen
am 28 Dez. 2015
Bearbeitet: Kirby Fears
am 28 Dez. 2015
Does anyone know what I'm doing wrong here? In the first part of the code, what I want to do is perfectly working. But in the scond part, excel keeps giving me 'soleus' for all the 6 columns instead of the six different muscles.
names2 = {'soleus' 'tibant' 'gaslat' 'vaslat' 'rectfem' 'hamlat'};
xlswrite('gait',names2,'B1:G1');
xlswrite('gait',MeanGait,'B2:G101');
xlswrite('gait',StdGait,'Feuil2','B2:G101');
xlswrite('gait',names2,'Feuil2','B1:G1');
motion = { 'Gait', 'StairUp', 'StairDown' };
names2 = {'soleus' 'tibant' 'gaslat' 'vaslat' 'rectfem' 'hamlat'};
xlswrite('Muscle Duration',names2,'AdDB','A2:A7');
xlswrite('Muscle Duration',motion,'AdDB','B1:D1');
xlswrite('Muscle Duration',MuscleActivity.AdDB,'AdDB','B2:D7')
Thank you!
1 Kommentar
Sivakumaran Chandrasekaran
am 28 Dez. 2015
just now i checked this. you can do from columns to columns.. but not from row to row. however it will have some other option . let me tell you tmrw. interesting question and interesting MATLAB
Akzeptierte Antwort
Kirby Fears
am 28 Dez. 2015
Bearbeitet: Kirby Fears
am 28 Dez. 2015
When writing to a row, specify your data as a row vector. When writing to a column, specify your data as a column vector.
In your code:
xlswrite('Muscle Duration',names2,'AdDB','A2:A7');
Column A from 2 to 7 is the output range (a column vector) but names2 is a row vector. Just apply the transpose operator (apostrophe) to names 2 to make it a column vector.
xlswrite('Muscle Duration', names2','AdDB','A2:A7');
0 Kommentare
Weitere Antworten (0)
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!