How to read multiple excel files with different names

Hi everyone, I have 41 excel files that I have to import to MATLAB. From these files I need to get the value of a specific cell (for every file the cell number and letter are the same). I would like to create an arrow containing the all the values from each of the file. Any idea how I can do it?

Thank you!!

[Stephen23]

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

Answer 1

[xi]

you can use this commend to select multiple files from the same folder..

[files,path]=uigetfile('*.xlsx','multiselect','on')

and then use xlsread to access data in each file. and do whatever you want. see xlsread

for i=1:41
[~, ~, data{i}]=xlsread(fullfile(path,files{i}))
end