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

Question

zina shadidi 2020-11-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/641330-how-can-n-i-export-file-with-excle-format-with-fprintf

评论： 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)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Subhadeep Koley 2020-11-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/641330-how-can-n-i-export-file-with-excle-format-with-fprintf#answer_538465

在 MATLAB Online 中打开

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更早的评论隐藏 1更早的评论

Subhadeep Koley 2020-11-9

编辑：Subhadeep Koley 2020-11-9

在 MATLAB Online 中打开

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);