Write Data to Excel
6 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
nick12391
el 16 de Jul. de 2019
Respondida: Walter Roberson
el 16 de Jul. de 2019
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.
0 comentarios
Respuesta aceptada
Más respuestas (2)
KSSV
el 16 de Jul. de 2019
x = rand(3,1) ;
y = rand(3,1) ;
z = rand(3,1) ;
T = table(x,y,z) ;
writetable(T,'test.xlsx')
0 comentarios
Walter Roberson
el 16 de Jul. de 2019
T = table(cellstr(var).', val.');
writetable(T, filename, 'Sheet', 1, 'Range', 'A1', 'writevariablenames', false)
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!