MATLAB: I want to combine only first column of first and second excel file to make 1 excel file (save individually as 1.xlsx) and then second column of first and second excel file to make another excel file as 2.xlsx.

joshua

Hlo
First excel file
1 2 3
1.1 2.2 3.3
80 90 91
Second Excel file
4 5 6
4.4 5.5 6.6
88 87 86
I want to combine only first column of first and second excel file to make 1 excel file (save individually as 1.xlsx) and then second column of first and second excel file to make another excel file as 2.xlsx.
Can someone help me to solve this problem.

Best Answer

%% read1
file1='file11';file2='‏‏file12';
N=256;
col1=xlsread(file1,1,strcat('A1:A',num2str(N)));
col2=xlsread(file2,1,strcat('A1:A',num2str(N)));
Data1=[col1,col2];
%% read2
col1=xlsread(file1,1,strcat('B1:B',num2str(N)));
col2=xlsread(file2,1,strcat('B1:B',num2str(N)));
Data2=[col1,col2];
%% write
xlswrite('1.xlsx', Data1);
xlswrite('2.xlsx', Data2);
Related Question