How do I import many excel files from one folder using a for loop?

Hi guys, very simple concept and I am new to matlab.

I want to know how to import data using xlsread via a for loop. For example:

myFolder = 'D:Miguel\Matlab Work\Raw Solar Data'   %Path to the folder with the raw .xlsx files

I want to be able to save these files as variables in matlab (Data1, Data2, etc.).

I've tried a few things but nothing seems to work. Also, I want to be able to see what file is being saved.

   filePattern = fullfile(myFolder, '*.xlsx'); 
theFiles = dir(filePattern);
for k = 1 : length(theFiles)
  baseFileName = theFiles(k).name;
  fullFileName = fullfile(myFolder, baseFileName);
  fprintf(1, 'Saving %s\n', fullFileName);
  Data{k} = xlsread(theFiles(k)); % code
  end

Answer 1

[Walter Roberson]

That reading code looks pretty good. However, notice that you have

myFolder = 'D:Miguel\Matlab Work\Raw Solar Data'   %Path to the folder with the raw .xlsx files

Remember that in MS Windows, if the first character after the drive letter colon is not a / or a \ then the path given does not generally refer to the root directory. The fix might be as simple as

myFolder = 'D:\Miguel\Matlab Work\Raw Solar Data'   %Path to the folder with the raw .xlsx files