load a folder of excel files

hi

i have 146 excel files in a folder and want to load them all

i dont want to go through import window everytime, so is there a way to load all at once?

[Stephen23]

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

Answer 1

[KSSV]

excelFiles = dir('*.xlsx') ; 
N = length(excelFiles) ;
for i = 1:N
    file = excelFiles(i).name ;
    T = readtable(file) ;
    % do what you want 
end

[Kamyar Mazarei]

thank you

the T gives me a table, can i turn it into a matrix?

(the excels are all numbers not letters)

[Stephen23]

"the T gives me a table, can i turn it into a matrix?"

https://www.mathworks.com/help/matlab/ref/readmatrix.html