I want to access multiple excel files from multiple folders and extract specific cell values.

2 views (last 30 days)
Preethi
Preethi on 21 Jun 2022
Commented: Preethi on 22 Jun 2022
I have multiple folders that consist of multiple subfolders that in turn consist of multiple excel files. I want to extract 3 specific cell values from each of these excel files. I'm a beginner in MATLAB and self-taught. Any help would be much appreciated.
Thank you!

Answers (1)

Sulaymon Eshkabilov
Sulaymon Eshkabilov on 21 Jun 2022
You may consider using this kind of approach:
MY_Folder= '...\MATLAB'; % Specify your folders where your data files are residing
FILE_Pattern = fullfile(MY_Folder, '*.xlsx'); % Specify MS Excel file extension
FILES = dir(FILE_Pattern);
F_names = {FILES.name};
for jj = 1 : length(F_names)
BFileName = FILES(jj).name;
F_FileName = fullfile(FILES(jj).folder, BFileName);
fprintf(1, 'Now reading %s\n', F_FileName);
DATA{jj} = readtable(F_FileName, 'Sheet', ???, 'Range', ???); % Specify the sheet name and cells where your data are located
...
end
  2 Comments

Sign in to comment.

Products


Release

R2019a

Community Treasure Hunt

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

Start Hunting!