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

1 view (last 30 days)
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??

Accepted Answer

Mischa Kim
Mischa Kim on 21 Apr 2014
Edited: Mischa Kim on 21 Apr 2014
Use
xlsread(myfilename,'A:E')
or any other range of data columns.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!