how do i merge multiple excel files into a single input

I have multiple files that i would like to merge as a single input. What function do i have to use?

Answer 1

[KSSV]

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.