Write Data to Excel

5 次查看（过去 30 天）
nick12391
nick12391 2019-7-16
回答： Walter Roberson 2019-7-16
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.

请先登录，再回答此问题。

采纳的回答

nick12391
nick12391 2019-7-16
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')

更多回答（2 个）

KSSV
KSSV 2019-7-16
x = rand(3,1) ;
y = rand(3,1) ;
z = rand(3,1) ;
T = table(x,y,z) ;
writetable(T,'test.xlsx')
Walter Roberson
Walter Roberson 2019-7-16
T = table(cellstr(var).', val.');
writetable(T, filename, 'Sheet', 1, 'Range', 'A1', 'writevariablenames', false)

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by