reading multiple .mps files in a loop

I have about 100 .mps files of raw data and need to process this info(they are all stored in a folder). I want to read each file, extract a specific section of each of the files (from 1:4 coloums), find the maximum value in each of this extracted data (for each file) and store this max data separately. How can I go about this?

Thanks!

[Stephen23]

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

[Mathieu NOE]

hello

example for excel files below , adapt to your own needs :

fileDir = pwd;
sheet = 2; % data must be retrieved from sheet #2

S = dir(fullfile(fileDir,'*.xlsx')); % get list of data files in directory
S = natsortfiles(S); % sort file names into natural order (what matlab does not) , see FEX : 
           %(https://fr.mathworks.com/matlabcentral/fileexchange/47434-natural-order-filename-sort)
          
for k = 1:length(S)
    
    data = xlsread(fullfile(fileDir, S(k).name),sheet); % or use a structure (S(k).data ) to store the full data structure
    % your code here
    
end