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.

Question

VIKAS POONIA 2019-12-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/497410-i-want-to-combine-only-first-column-of-first-and-second-excel-file-to-make-1-excel-file-save-indivi

评论： VIKAS POONIA 2019-12-23

采纳的回答： ariel gerber

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.

2 个评论
显示无隐藏无

Bob Thompson 2019-12-19

This should be fairly easy to do using xlsread and xlswrite.

What do you have so far for your code? Are you stuck on the commands to use, or is there a more specific error you keep running into?

VIKAS POONIA 2019-12-19

Thank you Sir.

Sir, Ifound the solution.

Thanks again

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

ariel gerber 2019-12-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/497410-i-want-to-combine-only-first-column-of-first-and-second-excel-file-to-make-1-excel-file-save-indivi#answer_407087

在 MATLAB Online 中打开

%% 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);