Info
此问题已关闭。 请重新打开它进行编辑或回答。
xlsread function does not concatenate all files into one big matrix as expected
1 次查看(过去 30 天)
显示 更早的评论
Hello,
I am working with a few .xlsx files which I want to concatenate into one, big matrix. Attached you find examples of 4 files and below you have the piece of code I am currently playing with:
folder='D:\Documents\...'; % my folder
filetype='*_pilot_trivia.xlsx';
f=fullfile(folder,filetype);
d=dir(f);
all_participants = [];
for k=1:size(d,1); % using 'numel' instead of 'size' doesn't help
all_participants = xlsread(fullfile(folder,d(k).name));
end
Basically what happens is that everything goes smoothly except the fact that only one specific file out of the entire list gets loaded (i.e. only 9_pilot_trivia.xlsx appears in all_participants in the end) and I don't know why. Could you please be so kind as to help?
0 个评论
回答(0 个)
此问题已关闭。
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!