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

 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)

Answer 1

[Subhadeep Koley]

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

[zina shadidi]

Subhadeep koley . This function is not defined in Matlab 2018 release. So I cant use it

[Subhadeep Koley]

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]

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 .