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

11 views (last 30 days)
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)

Accepted Answer

Subhadeep Koley
Subhadeep Koley on 9 Nov 2020
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 Comments
zina shadidi
zina shadidi on 9 Nov 2020
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 .

Sign in to comment.

More Answers (0)

Products


Release

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by