how can n I export file with Excle format, with fprintf

3 次查看（过去 30 天）
zina shadidi
zina shadidi 2020-11-9
评论： zina shadidi 2020-11-9
how can I export file with Excle format, with fprintf
i have the flowing lines :
fid:fopen ('elements. txt', 'w')
fprintf (fid, %15.10f %15.10f %15.10f/n',elements)
these lines make a text file wich is not readable by another code)

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

采纳的回答

Subhadeep Koley
Subhadeep Koley 2020-11-9
fprintf can only write data to text file. It cannot write data to Excel file. TO write data in Excel format use the function writematrix
% Creating a random data, replace this with your data
elements = rand(100, 4);
% Write to .txt file
fid = fopen ('elements.txt', 'w');
fprintf (fid, '%15.10f %15.10f %15.10f\n', elements);
% Write to .xlsx file
writematrix(elements, 'elements.xlsx');
  3 个评论
显示 1更早的评论
Subhadeep Koley
Subhadeep Koley 2020-11-9
编辑：Subhadeep Koley 2020-11-9
zina shadidi you can achieve the same result with the function writetable too. writetable is available in MATLAB r2018.
% Creating a random data, replace this with your data
elements = rand(100, 4);
% Write to .txt file
fid = fopen ('elements.txt', 'w');
fprintf (fid, '%15.10f %15.10f %15.10f\n', elements);
% Write to .xlsx file
writetable(array2table(elements), 'elements.xlsx',...
'WriteVariableNames', false);
zina shadidi
zina shadidi 2020-11-9
Thanks a lot subhadeep koley , it works , but let me ask you please how can l arrange the elements in Exle file as in text file in two coloumn .

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by