What is the fastest way to export a large matrix of numbers from MATLAB to Excel (preferably as .xlsx) ?
조회 수: 20 (최근 30일)
이전 댓글 표시
What is the fastest way to export a large matrix of numbers from MATLAB to Excel (preferably as .xlsx) ?
It looks like there are several ways, such as writematrix, writecell, writetable, xlswrite, csvwrite (apparently, xlswrite and csvwrite are not recommended), etc, but which one is the fastest one for large matrices ?
% Example of matrix of numbers to be exported from Matlab to Excel (preferably as .xlsx):
M = magic(10^3);
댓글 수: 0
채택된 답변
Jan
2022년 11월 19일
편집: Jan
2022년 11월 19일
Simply try it:
M = magic(10^3);
tic;
writematrix(M, 'file1.xlsx');
toc
tic;
writecell(num2cell(M), 'file2.xlsx');
toc
tic;
writetable(table(M), 'file3.xlsx');
toc
tic;
xlswrite('file4.xlsx', M);
toc
tic;
csvwrite('file5.csv', M);
toc
tic;
fid = fopen('file6.csv', 'W');
fmt = [repmat('%g, ', 1, 999), '%g\n'];
fprintf(fid, fmt, M.');
fclose(fid);
toc
tic;
fid = fopen('file7.csv', 'W');
fmt = [repmat('%g, ', 1, 999), '%g\n'];
fwrite(fid, sprintf(fmt, M.'), 'char');
fclose(fid);
toc
추가 답변 (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!