Matlab code for accessing different folder data

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!!

[Stephen23]

@Arijeet Sinha: loop over the folders, read the file data. What have you tried so far?

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

[Arijeet Sinha]

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.

Answer 1

[Stephen23]

Very similar to the MATLAB documentation shows:

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

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.

Answer 2

[Jan]

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