I want to access multiple excel files from multiple folders and extract specific cell values.
8 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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!
0 comentarios
Respuestas (1)
Sulaymon Eshkabilov
el 21 de Jun. de 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 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!