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

1 次查看（过去 30 天）
Franchesca
Franchesca 2014-4-18
评论： Franchesca 2014-4-20
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.

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2014-4-18
  1 个评论
Franchesca
Franchesca 2014-4-20
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by