how do i merge multiple excel files into a single input
조회 수: 1 (최근 30일)
이전 댓글 표시
I have multiple files that i would like to merge as a single input. What function do i have to use?
댓글 수: 0
답변 (1개)
KSSV
2018년 1월 16일
Read about xlsread . With this you can read excel data into matlab.
files = dir('*.xls') ; % Excel file extension
N = length(files) ; % total files
iwant = cell(N,1) ;
for i = 1:N
[num,txt,raw] = xlsread(files(i).name) ;
iwant{i} = num ;
end
Now you have all the data of excel files in iwant. You can write that into a single file.
댓글 수: 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!