read multiple excel files with different file names ?

I want to multiple excel files with different file names like R1 (1).xlsx, R1 (2).xlsx, R1 (3).xlsx........... till R1 (30).xlsx and want to extract data having same sheet name and column number in each excel files. lets say Sheet name is "ABC" in each excel file and want to extract column T and U from this sheet from all the sheets.

[Stephen23]

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

Answer 1

[KSSV]

xlFiles = dir("*.xlsx") ;
N = length(xlFiles) ; 
for i = 1:N
    thisFile = xlFiles(i).name ; 
    T = readtable(thisFile) ;  
    % do what you want 
end

[mukesh meharda]

How to read Sheet name having "ABC" and extract data from column T:U from each excel file ?

[KSSV]

You can use xlsread.Read the action.

[mukesh meharda]

then I have to write this 30 times for each excel files

[KSSV]

Put in a loop....idea is already given in the answer.