Opening many excel files into different matrices
조회 수: 2 (최근 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!