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.

1 次查看（过去 30 天）
VIKAS POONIA
VIKAS POONIA 2019-12-19
评论： VIKAS POONIA 2019-12-23
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.

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

采纳的回答

ariel gerber
ariel gerber 2019-12-19
%% 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);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by