Write Data to Excel

I'm trying to output variables from my code to an Excel spreadsheet.

var = ['L_Chamber'; 'D_Chamber'; 'D_Throat '; 'L_Nozzle '; 'D_Nozzle '; 'Theta_N  '];
val = [L_Chamber; D_Chamber; D_Throat; L_Nozzle; D_Exit; theta_n];
T = table(var,val);
filename = 'TCA_Dims.xlsx';
writetable(T',filename,'Sheet',1,'Range','A1')

This code works well, but I would like for the variable names, 'var', to be written to the top row, and their values, 'val', to be written to the second row. As it is, var and val are written to the first and second columns, respectively.

Answer 1

[nick12391]

Nevermind, I figured it out:

Table = table(L_Chamber, D_Chamber, D_Throat, L_Nozzle, D_Exit, theta_n);
filename = 'TCA_Dims.xlsx';
writetable(Table,filename,'Sheet',1,'Range','A1')

Answer 2

[KSSV]

x = rand(3,1) ; 
y = rand(3,1) ; 
z = rand(3,1) ; 
T = table(x,y,z) ; 
writetable(T,'test.xlsx')

Answer 3

[Walter Roberson]

T = table(cellstr(var).', val.');
writetable(T, filename, 'Sheet', 1, 'Range', 'A1', 'writevariablenames', false)