how do i merge multiple excel files into a single input
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
I have multiple files that i would like to merge as a single input. What function do i have to use?
0 Kommentare
Antworten (1)
KSSV
am 16 Jan. 2018
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 Kommentare
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!