Changing file path and load multiple files

I have some folders where i have saved several files where code changes and I need to load each file. I need help

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

[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?

[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);