How to read multiple excel files with pattern in their names

Question

DONGUK KIM 2019-11-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/488938-how-to-read-multiple-excel-files-with-pattern-in-their-names

回答： Image Analyst 2019-11-3

As the title says, I want to read multiple excel files that have a pattern in their names.

The file names start from 1000 to 100000, increasing with an interval of 1000.

Thanks in advance.

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

请先登录，再进行评论。

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

Answer 1

Bhaskar R 2019-11-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/488938-how-to-read-multiple-excel-files-with-pattern-in-their-names#answer_399555

在 MATLAB Online 中打开

% assuming working in the present working directory 
files = 1000:1000:100000;
file_data = cell(1, length(files));
for iFile = 1:length(files)
    % in string concatamatiom
    % 1 - if filename has any pre string
    % 2 - for loop varibale from 1000:1000:100000
    % 3 - file extension
    str = ['file_pre_string_if_any_', num2str(iFile), '.xlsx'];
    file_data{iFile} = xlsread(str);    % excel data will be stored in the variable file_data
end