Reading Excel files with ‘xlsread’ inside your fitness function every time it is called is very inefficient, especially during optimization where the fitness function is evaluated thousands of times. The best practice is to read the data only once before the optimization starts and then pass it as parameters to your fitness function.
An example implementation of this solution is given:
% Read tables once before optimization
data1 = readtable('first_file.xlsx');
data2 = readtable('second_file.xlsx');
% Pass the pre-loaded data to objective function
fitnessFcn = @(x) objective_function(x, data1, data2);
% Run optimization
[x, fval] = gamultiobj(fitnessFcn, nvars);
Additionally, for newer versions of MATLAB, it is recommended to use ‘readtable’ instead of ‘xlsread’ as ‘readtable’ is generally faster, more robust, and more flexible for reading Excel files.
