Problem with data saving in a for loop

Question

Tony Castillo 2019-10-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/484641-problem-with-data-saving-in-a-for-loop

评论： Tony Castillo 2019-10-11

AnalisisEscenarios_Excel_Mar.m

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

prasanth s 2019-10-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/484641-problem-with-data-saving-in-a-for-loop#answer_395769

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Tony Castillo 2019-10-11

Thank you so much this insight worked perfectly.

请先登录，再进行评论。

Answer 2

prasanth s 2019-10-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/484641-problem-with-data-saving-in-a-for-loop#answer_395774

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.