Taking 100 seconds to Creatworkbook, why is that?

2 次查看（过去 30 天）

ZHUOAN LIANG 2019-6-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/465961-taking-100-seconds-to-creatworkbook-why-is-that

评论： Image Analyst 2019-6-17

Dear all,

When I am using Matlab on my own laptop, everytime when I try to run the following code:

% load data
data = readtable('John.xlsx');
% extract series from the whole dataset
spspot = data(:,2);
logspspot = log(spspot{:,1});
djspot = data(:,3);
logdjspot = log(djspot{:,1});
nyspot = data(:,4);
lognyspot = log(nyspot{:,1});
spfut = data(:,5);
logspfut = log(spfut{:,1});
% Group the corresponding data series
grp1 = [logdjspot logspfut];
grp2 = [logspspot logspfut];
grp3 = [lognyspot logspfut];

It would take 100+ seconds, out of these time, 100 seconds are devoted to "CreateWorkbook" which is presented in the screenshot attached. I am sure it is not the problem with the Excel spreadsheet nor the data, as these code can be run very easily on the University's pc.

Thanks everyone in advanced for helping!