how can n I export file with Excle format, with fprintf
4 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
採用された回答
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 件のコメント
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);
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!