How do I import a number of excel files at once?

I have wrote this loop to import a number of excel files at once and it works:

numfiles = 54; % number of excel files mydata=cell(numfiles,1); % defining size of mydata

for k = 7:numfiles % loop to import mutliple excel files

    myfilename = sprintf('Trial %d', k); % define file name 

    mydata{k} = xlsread(myfilename); % import files into mydata

end

How do I edit this to only import columns 1 to 5 in each excel file??

Answer 1

[Mischa Kim]

Use

 xlsread(myfilename,'A:E')

or any other range of data columns.