Using something faster than xlswrite()?

3 次查看（过去 30 天）
ck
ck 2016-6-27
编辑： Image Analyst 2016-6-28
I am using xlswrite to save the outputs each time, so this calls to open excel and its consuming a lot of time. Is there any other faster process for this ?

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

回答（2 个）

Star Strider
Star Strider 2016-6-27
I’m not certain what you’re doing, but I would save the intermediate results to a numeric or cell array, then save the array after the loop in one xlswrite call.
  1 个评论
ck
ck 2016-6-27
Yeah, I used xlswrite after getting the whole output to save it, but even one call is taking aroung 3 sec atleast!

请先登录，再进行评论。

Image Analyst
Image Analyst 2016-6-27
If by "each time" you mean in a loop, yes, that will take forever, except for more modern versions, like R2015b or later. That's each time you call xlswrite() it has to launch Excel, toss in your data, then shut down Excel. Later versions leave Excel running, which is faster (but which causes other problems by the way). So, what version are you running?
Like Star said, a faster way for all versions is to build your cell array only and THEN write a cell array with a single call to xlswrite().
  4 个评论
显示 2更早的评论
ck
ck 2016-6-28
b is a 6x1 matrix , so if I call it once it takes around 3 or 3.5 sec.
Image Analyst
Image Analyst 2016-6-28
编辑：Image Analyst 2016-6-28
So just store b in a 2D array, then call xlswrite
b2d = zeros(6, 10); % Preallocate for speed.
for column = 1 : 10
% Get b
this_b = whatever.....
% Store in 2D array in this column.
b2d(:, column) = this_b;
end
xlswrite(filename, b2d, 'A1');

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by