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

1 次查看(过去 30 天)
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

回答(1 个)

Prajwal Venkatesh
Prajwal Venkatesh 2020-1-17
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?

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by