how can n I export file with Excle format, with fprintf
9 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
zina shadidi
le 9 Nov 2020
Commenté : zina shadidi
le 9 Nov 2020
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 commentaires
Réponse acceptée
Subhadeep Koley
le 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 commentaires
Subhadeep Koley
le 9 Nov 2020
Modifié(e) : Subhadeep Koley
le 9 Nov 2020
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);
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!