How do I import many excel files in MATLAB?
조회 수: 1 (최근 30일)
이전 댓글 표시
I use a code, like this. But Just 1 of 5 file is imported. I want to import 5 files.
source_dir = 'C:/Users/Cju/Documents/MATLAB/a/' ;
dest_dir = '/C:/Users/Cju/Documents/MATLAB/a' ;
source_files = dir(fullfile(source_dir, '*.xlsx'));
for i = 1:length(source_files)
data = xlsread(fullfile(source_dir, source_files(i).name));
xlswrite(fullfile(dest_dir, source_files(i).name));
end
댓글 수: 2
louis rassinfosse
2016년 4월 29일
편집: louis rassinfosse
2016년 4월 29일
I suppose only your last file is imported? That is because the name data, is the same for all 5 files..
Try:
-----------------------
For i=...
Data(i) =...
End
----------------------
(Not sure if it is '(i)' or {i}' but one should work )
John BG
2016년 4월 29일
With your for loop writing the output of xlsread in exactly the same variable called 'data' you will not be able to read any other spreadsheet than the last one.
First build different variables, or a matrix the size you want to hold the data, fill it up with zeros if dealing with numeric, or build a basic cell that you can concatenate in the same for loop and then read with the for loop:
data={}
for k=1:N_files
[d1 d2 d3]=xlsread(...)
data=[data ; d3]
end
check your syntax of xlsread and xlswrite, the:
- variables
- worksheet page
- cell ranges
are missing.
답변 (1개)
louis rassinfosse
2016년 4월 29일
I suppose only your last file is imported? That is because the name data, is the same for all 5 files..
Try:
-----------------------
For i=...
Data(i) =...
End
----------------------
(Not sure if it is '(i)' or {i}' but one should work )
댓글 수: 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!