Changing file path and load multiple excel files

I have some specific folders where i have saved several excel files with the filename in the following format:

code_parameterA_year.xls, code_parameterB_year.xls, etc

where code and year changes and I need to load each excel file. I need help loading each excel file using the following code:

path = pwd
code='station1';
year='2022';
S = readtable(fullfile(path, code '_parameterA_' year'.xls'));                                                                                                                       

Answer 1

[Image Analyst]

Use a file data store fileDatastore

% Specify the top level folder.
topLevelFolder = pwd; % Wherever it is....
% Process a sequence of files.
filePattern = fullfile(topLevelFolder, '*.xls*');
fds = fileDatastore(filePattern, 'ReadFcn',@readtable) % Create an image Datastore
% Get all filenames into one cell array.  Filenames have the complete path (folder prepended).
allFileNames = fds.Files;
numFiles = numel(fds.Files);
for k = 1 : numel(allFileNames)
    % Get this file name.
    fullFileName = allFileNames{k};
    fprintf('Processing %s\n', fullFileName);
    % Now do something with fullFileName, such as passing it to readtable().
end

[Ancalagon8]

Thank you for your answer @Image Analyst. Somehow I need inside the loop to use readtable with the requested format:

readtable(fullfile(path, code '_parameterA_' year'.xls'));  

[Image Analyst]

If you don't want the order the operating system gives you, then you can have for loops over code and year and build up the filename with sprintf().

See the FAQ: https://matlab.fandom.com/wiki/FAQ#How_can_I_process_a_sequence_of_files?

[Ancalagon8]

using the above code from the FAQ link, I succesfully loaded all excel files:

filePattern = fullfile(myFolder, '*.xls');
theFiles = dir(filePattern);
for k = 1 : length(theFiles)
    baseFileName = theFiles(k).name;
    fullFileName = fullfile(theFiles(k).folder, baseFileName);
    fprintf(1, 'Now reading %s\n', fullFileName);
    data=readtable(fullFileName)
end

but data table only stores the last excel. Do you now why?

[Image Analyst]

Yes, you just load the workbook file into the "data" variable and then you never do anything with data. Plus on every iteration data is overwritten by the current workbook so at the very end you'll only have data from the very last workbook. If you want to do something with data, then do so. If you also want to save it for use later, outside the loop, then you'll need to save it somehow, like in a cell array.

https://matlab.fandom.com/wiki/FAQ#What_is_a_cell_array?

data{k} = readtable(fullFileName);