Import and export excel files

Hello everyone,

I am trying to collect data of column "C" from each excel file and export the data into an excel file using for loop function.

When I open up the exported file "Load_of_samples", All data are the same as the column of the "first" excel file. (column A is the data from the first excel file, and the rest of columns (B~D) are the same as column A.

I am wondering what I did wrong.

Thank you.

XLfile = dir('*.csv');
number_of_files = length(XLfile);
OutputFileName = 'Load_of_samples';

for i = 1:number_of_files
    filename = XLfile(i).name;  
    for i = 1:number_of_files
       A(:,i) = xlsread(filename,1,'C:C');
    end
    xlswrite(OutputFileName,A);
end

Answer 1

[madhan ravi]

Processing sequence of files

[Cheeesepondue]

Thank you for you answer. Is there any way I can modify my functions slightly to get the desirable results, instead of following through the link?

[Walter Roberson]

remove the inner for loop just leaving the assignment to A(1,i)

[madhan ravi]

Thank you sir Walter :-)

[Cheeesepondue]

@Water Roberson The problem was the length of rows was different for each excel files.. So now I need to work on that.