本程序主要使matlab批量操作Excel表，其中用到了parfor并行計(jì)算加快處理速度。相同效果，速度上和Excel vba

是有差距的。

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

tic;

clear;

dirs=dir('E:我的文檔桌面寶貝銷售排行*.csv');

dircell=struct2cell(dirs);

len=length(dircell);

parfor j=1:len

filenames=dircell{1,j};

%%% 讀取原始表格數(shù)據(jù)

[a b c]=xlsread(filenames);

num=size(c,1);

date=c{1}(8:17);

c(1);

d={};

%%% 讀取原始表格數(shù)據(jù)

%%% 取出日期清空第一行

x=' ';

num_str=num2str(num);

range_all=strcat('A1:','Z',num_str);

xlswrite(filenames,x,range_all)

%%% 取出日期清空第一行

for i=2:num

%?空格顯示 NAN 被認(rèn)為是數(shù)字

if

~isnumeric(c{i,1})

d=[d;c(i,:)];?%c(i,:) 為原始表格中的第i行的所有元素

end

end

title='日期';

xlswrite(filenames,{title},1,'P1:P1');

num_date=num2str(num-1);

range_p=strcat('P2:','P',num_date);

xlswrite(filenames,{date},1,range_p);

xlswrite(filenames,d,1);

end

toc;

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎(jiǎng)勵(lì)來(lái)咯，堅(jiān)持創(chuàng)作打卡瓜分現(xiàn)金大獎(jiǎng)

總結(jié)

以上是生活随笔為你收集整理的matlab保存并关闭excel文件夹,[转载]Matlab批量操作目标文件夹下的Excel文件的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。