How to read excel as a source file from office 365 share point multile folders in one go

[bewiseavi]

How can we read excel (as a source file) from office 365 share point having 1 parent folders and then many sub folders, each subfolders has a excel file to read in one go.

Any help would be highly appreciated.

[Brett_Bleess]

Not sure this is exactly what you want, but it is an option:

https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543

https://community.qlik.com/t5/Qlik-Design-Blog/Wildcard-data-loading-blah/ba-p/1467768

Sorry I do not have anything better, you may still need to do directory changes, which I know you are trying to avoid.  Someone else may have something better, as my post will kick things back up to the top again.

Regards,
Brett