insertin string variables to headers

2 次查看(过去 30 天)
Hi all,
I have the matrix A which is A=
Columns 1 through 7
'l12' 'l13' 'l14' 'l15' 'l23'
and i want to apply something like
header={ 'time' A }; xlswrite('filename.xlsx', header) but it does not work as when i open the excel file i see as header only 'time' and not the elements of A.

采纳的回答

Jessica Lam
Jessica Lam 2012-5-23
hope it helps .....
output=cell(1,length(A));
output(1,1)=cellstr('time' );
output(1,2:length(A)+1)=num2cell(A);
xlswrite('filename.xlsx', output);
  1 个评论
antonet
antonet 2012-5-23
Hi jessica
Just a small correction and it seems that it works!
Instead of output(1,2:length(A)+1)=num2cell(A);
replace with output(1,2:length(A)+1)=A;
thank you

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Whos 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by