How can I combine data in multiple excel files an write the combined data in a new excel file data should be stored in column in excel file ?

17 次查看(过去 30 天)
suppose First excel file is that 1 5 7 2 7 9 second 3 9 8 4 5 2 final sheet should be like 1 5 7 2 7 9 3 9 8 4 5 2

采纳的回答

Michael Madelaire
Michael Madelaire 2017-10-21
I am not entirely sure what the question is. But if you have two files:
file1.xlsx
file2.xlsx
and want to combine the data in the files two one file:
file3.xlsx
Then you can do as follows:
data1 = xlsread('file1.xlsx'); % Load data from file 1
data2 = xlsread('file2.xlsx'); % Load data from file 2
data3 = [data1, data2]; % Create data for file 3
xlswrite('file3.xlsx', data3); % Create file 3
If you are using .csv files, then you can replace the functions with.
data = csvread(filename)
csvwrite(filename, data);
  3 个评论

请先登录,再进行评论。

更多回答(0 个)

Community Treasure Hunt

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

Start Hunting!

Translated by