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 ?
30 views (last 30 days)
Show older comments
Muhammad Salman Sarfraz
on 21 Oct 2017
Commented: SSG_newbiecoder
on 20 Apr 2018
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
0 Comments
Accepted Answer
Michael Madelaire
on 21 Oct 2017
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 Comments
Michael Madelaire
on 21 Oct 2017
You are welcome.
Yes, that would be the case if you want data3 to be a column. Which I now see is what you asked for! :)
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!