MATLAB Answers

Matlab code for accessing different folder data

4 views (last 30 days)
Arijeet Sinha
Arijeet Sinha on 11 Sep 2018
Answered: Jan on 4 May 2021
I have 20 excel file of data in 20 different folder. Want to access them all in one matlab code for plot. And can't put all in same folder. Actually all have same name. Need help!!
  2 Comments
Arijeet Sinha
Arijeet Sinha on 11 Sep 2018
I use loop to read the file data. It's working. But it's not storing the data. When read the next file, previous file data is loss. I want all the 20 excel file from different folder store in same workspace.

Sign in to comment.

Answers (2)

Stephen Cobeldick
Stephen Cobeldick on 11 Sep 2018
Edited: Stephen Cobeldick on 4 May 2021
Very similar to the MATLAB documentation shows:
you will want to either use dir or sprint to get the folder names. Something like this should work:
P = 'directory where the 20 subdirectories are';
S = dir(fullfile(P,'*'));
S = S([S.isdir]); % remove files
S = natsortfiles(S); % optional
for k = 1:numel(S)
F = fullfile(P,S(k).name,'filename.txt');
S(k).data = dlmread(F); % or whatever function reads your data.
end
All of your data will be in the structure array S.

Jan
Jan on 4 May 2021
Folder = 'C:\Base\Folder\';
FileList = dir(fullfile(Folder, '**', 'YourFile.xlsx'));
Data = cell(1, numel(FileList));
for k = 1:numel(FileList)
File = fullfile(FileList(k).folder, FileList(k).name);
Data{k} = readtable(File); % Or however you import the data
end

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by