Opening many excel files into different matrices

2 次查看（过去 30 天）
Konstantinos Belivanis
回答： Iain 2014-9-24
Hello all,
I have a large amount of excel files containing many rows and columns (different each time). I would like to load each file as a matrix with an ascending index in MATLAB. Till now, the only thing I have figured out is to create a big zero 3D matrix and filling it up.
The unfortunate event with this method is that I end up with many zeros that I don't want as all the z-direction matrices need to be of the same size.
Any idea?
Thanks a lot in advance!

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

采纳的回答

Iain
Iain 2014-9-24
A cell array would be ideal. Example:
list = {'file1.xls','C:\data\file2.xls', ....};
for i = 1:numel(list)
data{i} = xlsread(list{i});
plot(data{i}(:,1),data{i}(:,1)); hold all
end

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by