Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

New to MATLAB?

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

Asked by Franchesca

Franchesca (view profile)

on 18 Apr 2014
Latest activity Commented on by Franchesca

Franchesca (view profile)

on 20 Apr 2014

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.

0 Comments

Franchesca

Franchesca (view profile)

Products

No products are associated with this question.

1 Answer

Answer by Walter Roberson

Walter Roberson (view profile)

on 18 Apr 2014
Accepted answer

1 Comment

Franchesca

Franchesca (view profile)

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.

Walter Roberson

Walter Roberson (view profile)

Contact us