This is a bit complex, but worked for two random excel files. You can simplify if the two columns in each excel file are always the same length. If they aren't, simplifying creates breaks in the column with no data.
n=2; % number of files
data=[]; % initialize data matrix
for i=1:n
% if statement to name input file
if i-9<0
filename = ['tek000',num2str(i),'.xlsx'];
else
filename = ['tek00',num2str(i),'.xlsx'];
end
% checks if input file exists
if exist(filename, 'file') == 2
[num,txt,raw] = xlsread(filename);
[x,y]=size(num);
% checks to make sure each element in first column exists
for j=1:x
if(~isnan(num(j,1)))
data=[data;num(j,1)];
end
end
% checks to make sure each element in second column exists
for j=1:x
if(~isnan(num(j,2)))
data=[data;num(j,2)];
end
end
end
end
% writes extracted data to file
xlswrite('combined',data)
Here is the simplified code:
n=2; % number of files
data=[]; % initialize data matrix
for i=1:n
% if statement to name input file
if i-9<0
filename = ['tek000',num2str(i),'.xlsx'];
else
filename = ['tek00',num2str(i),'.xlsx'];
end
% checks if input file exists
if exist(filename, 'file') == 2
[num,txt,raw] = xlsread(filename);
[x,y]=size(num);
data=[data;num(:,1)];
data=[data;num(:,2)];
end
end
% writes extracted data to file
xlswrite('combined',data)
