MATLAB Answers

insertin string variables to headers

2 views (last 30 days)
antonet
antonet on 23 May 2012
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.

  0 Comments

Sign in to comment.

Accepted Answer

Jessica Lam
Jessica Lam on 23 May 2012
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 Comment

antonet
antonet on 23 May 2012
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

Sign in to comment.

More Answers (0)

Sign in to answer this question.


Translated by