How do I import multiple excel files from multiple folders , with different names and sizes?

Main folder has some n number of subfolders and these folders contain the excel files that I need to import to my program and store

[Rik]

This depends on how you want to store the data, but the dir function and a loop will probably do the trick.

Answer 1

[Prajwal Venkatesh]

clc;clear;

testfiledir = 'C:\Users\bidgu\OneDrive\Desktop\manpower';

matfiles = dir(fullfile(testfiledir, '*.xlsm'));

nfiles = length(matfiles);

datafi = cell(nfiles);

for i = 1 : nfiles

fid = fopen( fullfile(testfiledir, matfiles(i).name) );

datafi{i} = readtable(fid);

fclose(fid);

end

How do I use this code to read excel files?