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

Question

Preethi 2022-6-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1744875-i-want-to-access-multiple-excel-files-from-multiple-folders-and-extract-specific-cell-values

评论： Preethi 2022-6-22

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Sulaymon Eshkabilov 2022-6-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1744875-i-want-to-access-multiple-excel-files-from-multiple-folders-and-extract-specific-cell-values#answer_990430

在 MATLAB Online 中打开

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 个评论
显示无隐藏无

Preethi 2022-6-21

So the folder structure goes like this:

MainFolder/ subfolder1/subfolder2/file.xlsx

subfolder1 has many subfolder2's and these subfolder2's have hundreds of excel files in them. I just need A2, C3 and C5 data written to another csv file.

Preethi 2022-6-22