insertin string variables to headers

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.

Answer 1

[Jessica Lam]

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

[antonet]

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