How can I write excel file in MatLab

I have huge number of excel files. I have to collect certain data from each of the files and write all of them in a single excel file. How can I do it?

Answer 1

[Durgesh Naik]

filename = 'Book1_Test.xlsx'; A = {1 2 3 5 6 6 2 0.222 0.122 0.444}; B = {1 12 13 15 1 61 21}; sheet = 1; n = xlsread('Book1_Test.xlsx'); e = length(n); e = mat2str(e) xlRange = (['A' e+1])

xlswrite(filename,A',sheet,xlRange)

[Chandan Mahishi]

I want to collect data of power, current and efficiency. I have all those data in different files and want them in single excel file with one heading.