How to read multiple excel files with pattern in their names

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.

Answer 1

[Bhaskar R]

% 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

[DONGUK KIM]

What if the directory is in another folder? Also is it possible to read them as matrices?

Answer 2

[Image Analyst]

Use the first code chunk for this topic in the FAQ