Opening many excel files into different matrices
1 次查看(过去 30 天)
显示 更早的评论
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
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 个评论
更多回答(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!