How to save for loop data to same excel file of variable?

In my code for every for loop a output variable is calculated. So, I want to save the data of each loop in same sheet after the last line in excel. Is there any way to do so?

Answer 1

[Walter Roberson]

If you are using MS Windows with Excel installed then see https://www.mathworks.com/matlabcentral/fileexchange/28600-xlsappend

However, I would recommend that you consider saving all of the results in an array and appending only once all of the values are known, as the communication with Excel is comparatively expensive.

[Swapnil Rane]

Thank you so much. You are amazing. This was my last step of project.

[Parthiban Arumugam]

could you please explain how to call this function (above link) ?

can you put some example code here, if possible ?

[Walter Roberson]

In current releases I would use writetable or writematrix or writecell, with the option WriteMode 'append'