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

3 次查看（过去 30 天）
Miguel Herrera
Miguel Herrera 2017-8-17
回答： Walter Roberson 2017-8-17
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

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2017-8-17
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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by