I have some more additional code that imports the xlsx files but it's giving me errors for the num, input commands.
%this loop extracts data from excel files and fills them up in inputand
%output matrices - each column corresponds to 1 signal acquisition
%for input
for i=1:num
filename=sprintf('NewFile1_in.xlsx',i); %opens file for reading
filename2=sprintf('NewFile1_out.xlsx',i);
sheet=1; %sheet number in excel file
xlRange1='B2:B15039'; %row range of Channel 1 & 2
Input(:,i)=Input(:,i)+xlsread(filename,sheet,xlRange1);
Output(:,i)=Output(:,i)+xlsread(filename2,sheet,xlRange1);
end
filename3=sprintf('NewFile1_in.xlsx');
xlRange3='A2:A15039';
time_vec=xlsread(filename3,sheet,xlRange3);