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

1 次查看（过去 30 天）

显示更早的评论

Prajwal Venkatesh 2020-1-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500789-how-do-i-import-multiple-excel-files-from-multiple-folders-with-different-names-and-sizes

回答： Prajwal Venkatesh 2020-1-17

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

Rik 2020-1-17

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

请先登录，再进行评论。

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

回答（1 个）

Prajwal Venkatesh 2020-1-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500789-how-do-i-import-multiple-excel-files-from-multiple-folders-with-different-names-and-sizes#answer_410666

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Translated by