writing data to excel files

Question

Inti Vanmechelen 2015-12-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/261777-writing-data-to-excel-files

编辑： Kirby Fears 2015-12-28

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sivakumaran Chandrasekaran 2015-12-28

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

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Kirby Fears 2015-12-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/261777-writing-data-to-excel-files#answer_204485

编辑：Kirby Fears 2015-12-28

在 MATLAB Online 中打开

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');