Loading data from several subfolders

Hola mathworks community. I am struggling with a problem, perhaps someone on here can help?

I have a folder [the main folder] of 500 subfolders. Within these subfolders, there is another set of subfolders which contain seperate .xls files corresponding to a sample of a certain date. Total about 1000 xls files.

I would like to load and analyse all the xls files from all subfolders , direclty from the main folder without having to go in to them individually.

Is there away to do this?

Gracias,Ben

Answer 1

[KSSV]

This question is asked infinite times and discussed to death. Just a google will give you tons of links.

https://in.mathworks.com/matlabcentral/answers/401204-how-do-i-read-folders-with-subfolders

https://in.mathworks.com/matlabcentral/answers/401335-how-to-access-text-files-from-many-subfolders-within-a-folder

https://in.mathworks.com/matlabcentral/answers/245959-how-to-read-text-files-from-different-sub-folders-in-a-folder