insertin string variables to headers

3 visualizzazioni (ultimi 30 giorni)
antonet
antonet il 23 Mag 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.

Risposta accettata

Jessica Lam
Jessica Lam il 23 Mag 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 Commento
antonet
antonet il 23 Mag 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

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Characters and Strings in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by