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

1 view (last 30 days)
I have managed to write a loop which imports all the files into matlab however, it has imported them all into one matrix and to open an excel file I go into the matrix and have to double click the cell to open another matrix with all my data within it. The code is shown below:
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
What I require is a loop which imports the excel files in one go into individual matices so that I can process the data.
It would be great if you can help.

Accepted Answer

Walter Roberson
Walter Roberson on 18 Apr 2014
  1 Comment
Franchesca
Franchesca on 20 Apr 2014
Thank you for the answer, however it says:
You should save them to an array or cell array if you need to use them outside the loop, otherwise use them immediately inside the loop.
How do I save them to an array or cell array?
Below the picture shows how they are saved in Matlab at the moment, however I can't seem to open individual cells when writing my code to process the data. So is there a way to save each file as an individual variable or is there a code which allows me to go into this variable below and open a cell to then process the data.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!