MATLAB: How to import a number of excel files at once

Question

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

Use

 xlsread(myfilename,'A:E')

or any other range of data columns.