Problem with data saving in a for loop

Hi all,

I have prepared a script to execute a code in 3 different folders, even though, I can verify that my script go through the 3 folders calculating my variables, in the end I have one problem it only writes into my excel sheet the last values calculated(in the last folder, overwriting the values calculated in the former 2 folders), how can I fix the code for obtaining my three columns with their variables?, the code is attached.

Thanks in advance

Answer 1

[prasanth s]

you have to put the 'xlswrite' functions inside the for loop. also, for each iteration, change the sheet number or the 'xlRange' (selected columns).

[Tony Castillo]

Thank you so much this insight worked perfectly.

Answer 2

[prasanth s]

Best solution is:

store the output variable 'vector' fom each iteration, into another variable(array, cell array). then at the end of program, write all data to the sheet.