What is the fastest way to export a large matrix of numbers from MATLAB to Excel (preferably as .xlsx) ?

Question

Sim 2022-11-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1856843-what-is-the-fastest-way-to-export-a-large-matrix-of-numbers-from-matlab-to-excel-preferably-as-xls

评论： Sim 2022-11-19

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jan 2022-11-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1856843-what-is-the-fastest-way-to-export-a-large-matrix-of-numbers-from-matlab-to-excel-preferably-as-xls#answer_1105393

编辑：Jan 2022-11-19

在 MATLAB Online 中打开

Simply try it:

M = magic(10^3);
tic;
writematrix(M, 'file1.xlsx');
toc
Elapsed time is 5.094270 seconds.
tic;
writecell(num2cell(M), 'file2.xlsx');
toc
Elapsed time is 10.870852 seconds.
tic;
writetable(table(M), 'file3.xlsx');
toc
Elapsed time is 4.806810 seconds.
tic;
xlswrite('file4.xlsx', M);
Warning: Unable to write to Excel format, attempting to write file to CSV format.
toc
Elapsed time is 0.736247 seconds.
tic;
csvwrite('file5.csv', M);
toc
Elapsed time is 0.481182 seconds.
tic;
fid = fopen('file6.csv', 'W');
fmt = [repmat('%g, ', 1, 999), '%g\n'];
fprintf(fid, fmt, M.');
fclose(fid);
toc
Elapsed time is 0.402371 seconds.
tic;
fid = fopen('file7.csv', 'W');
fmt = [repmat('%g, ', 1, 999), '%g\n'];
fwrite(fid, sprintf(fmt, M.'), 'char');
fclose(fid);
toc
Elapsed time is 0.424347 seconds.