Tabulating the data obtained for my Matlab code
1 次查看(过去 30 天)
显示 更早的评论
With the code I stated below, I obtain 2 column graphic data as x and y. The data I obtained appear separately on the right. One writes as a column, the other as a row. I would like help in updating my code to create a txt or Excel file with these two data as columns from top to bottom.
The data I obtained look like this, separately, one as a column and the other as a graph. I want it to give me this data as columns in txt or excel.
I upload the data I use for the code to work as a txt file.
data = readmatrix('Naca LD0006 6R.txt');
f = fit(data(:,1), data(:,2),'smoothingspline','SmoothingParam',0.3);
xi = -15:1:18; % or -15:0.5:18 or whatever
yi = f(xi);
figure
plot(f,data(:,1),data(:,2))
hold on
plot(xi,yi,'o','MarkerFaceColor','g','DisplayName','1° intervals')
set(get(gca(),'Legend'),'Location','best');
0 个评论
回答(1 个)
Star Strider
2024-5-20
编辑:Star Strider
2024-5-20
Create a table array with your variables (that I assume are ‘xi’ and ‘yi’ here) and then use writetable to save them as an Excel file. Use the colon, : operator to force both of them to be column vectors.
Try this —
data = readmatrix('Naca LD0006 6R.txt');
f = fit(data(:,1), data(:,2),'smoothingspline','SmoothingParam',0.3);
xi = -15:1:18; % or -15:0.5:18 or whatever
yi = f(xi);
figure
plot(f,data(:,1),data(:,2))
hold on
plot(xi,yi,'o','MarkerFaceColor','g','DisplayName','1° intervals')
set(get(gca(),'Legend'),'Location','best');
Result = table(xi(:), yi(:), 'VariableNames',{'xi','yi'})
writetable(Result,'xi_yi.xlsx')
Read_xi_yi = readtable('xi_yi.xlsx')
EDIT — Corrected typographical error.
EDIT — (20 May 2024 at 20:40)
Added colon operator citation and link.
.
2 个评论
Star Strider
2024-5-21
My pleasure!
The writetable call creates an Excel file (that I call ‘xi_yi.xlsx’, you can call it whatever you want) that you should be able to open in Excel or any application that uses Excel and allows those files.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!