Create and save a table

32 次查看(过去 30 天)
How can i create and save a table from a multiple result of a function?
I used this command to print result on a file.dat
fprintf(fid1,' _______________________________________________________________________ \n');
fprintf(fid1,'r(m) b(r,t)(m) P(r,t)(Pa) r^2/t (m^2/s) Sw\n');
fprintf(fid1,' ________________________________________________________________ \n');
fprintf(fid1,'%15.2f %15.6f %15.6e %15.6e %12.4f\n',r,b_r,P,Sim,S_w)
and I've something like this
________________________________________________________________________
r(m) b(r,t)(m) P(r,t)(Pa) r^2/t (m^2/s) Sw
________________________________________________________________________
0.30 70.000000 2.068816e+07 2.853881e-09 0.3000
0.60 70.000000 2.060942e+07 1.141553e-08 0.3000
0.90 70.000000 2.056336e+07 2.568493e-08 0.3000
.... ........ ........ ........ ......
but i want the same result on a table .xls (for example) or .mat
Thanks for your help.

采纳的回答

Cris LaPierre
Cris LaPierre 2021-11-17
Since you already have the variables defined, I would create a variable of data type table.
varnames = ["r(m)" "b(r,t)(m)" "P(r,t)(Pa)" "r^2/t (m^2/s)" "Sw"];
r = [0.3 0.6 0.9]';
b_r = [70 70 70]';
P = [2.068816e7 2.060942e7 2.056336e7]';
Sim = [2.853881e-9 1.141553e-8 2.568493e-8]';
S_w = [.3 .3 .3]';
% create a table
T = table(r,b_r,P,Sim,S_w,'VariableNames',varnames)
T = 3×5 table
r(m) b(r,t)(m) P(r,t)(Pa) r^2/t (m^2/s) Sw ____ _________ __________ _____________ ___ 0.3 70 2.0688e+07 2.8539e-09 0.3 0.6 70 2.0609e+07 1.1416e-08 0.3 0.9 70 2.0563e+07 2.5685e-08 0.3
I could then write this table to an xlsx file using writetable.

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Tables 的更多信息

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by