Import many excel files to Matlab- How to?

Hey all I have over 50 .xlsx file in E:\test\ directory. how to import them in matlab in order to conduct some future performs?

thank you

[Turlough Hughes]

Can you attach an example of one of the excel sheets in the question?

[BN]

yes sure, here you are. I attached one of my excel files.

[Turlough Hughes]

Ok, are the files numbered? Like

Ahvaz_0001.xlsx
Ahvaz_0002.xlsx

Or how are they named / where are they stored?

[BN]

no they have very different names (city names) but all of them are in E:\test\ folder.

Answer 1

[dpb]

"...they have very different names (city names) but all of them are in E:\test\ folder."

Ok so just use the dir() solution (my preference almost always)...

rootdir='E:\test';
d=dir(fullfile(rootdir,'*.xlsx'));    % return list of .xlsx files in given subdirectory
for i=1:numel(d)
  t=readtable(fullfile(d(i).folder,d(i).name));   % use readtable here for example, choose whatever best for your use
  % do whatever with each file here...
  ...
end

As noted, above uses readtable as convenient way to read .xls files; there are other options depending upon just what the file structure is and what need to do with them...

Answer 2

[Turlough Hughes]

If all your data files are in that folder, and only your data files are in that folder and they are formatted the same, the following should work:

filepath='E:\test\folder'
fils=dir(filepath);
opts=detectImportOptions(fullfile(filepath,fils(1).name));
for c=1:length(fils)
    s.([fils(c).name])=readtable(fullfile(filepath,fils(c).name),opts);
end

You would in this case be saving to a struct called s.

I am depending on the files having the same format, alternatively you might use detectImportOptions on each iteration of the loop.

Answer 3

[Image Analyst]

Since this is a VERY Frequently asked question, see The FAQ