HI
I have multiple excel files at different folders. Lets say 10 excel files at 10 different folders. D:\1\1.xlsx…. to D:\10\10.xlsx!
I want to read the first column of each excel sheet and start it to ten variables in matlab. I am trying this, but didn't succeed. Can any one suggest me!
folder='D:\1\'; filetype='*1.xlsx'; f=fullfile(1,1); d=dir(f); for k=1:numel(d); data{k}=xlsread(fullfile(folder,d(k).xlsx)); end
Thanks
Matt
Best Answer