Matlab code for accessing different folder data

6 次查看（过去 30 天）
Arijeet Sinha
Arijeet Sinha 2018-9-11
回答： Jan 2021-5-4
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 个评论
Arijeet Sinha
Arijeet Sinha 2018-9-11
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.

请先登录，再进行评论。

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

回答（2 个）

Stephen23
Stephen23 2018-9-11
编辑：Stephen23 2021-5-4
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.
Jan
Jan 2021-5-4
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

类别

在 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