for loop & saving tables

Question

Aleksandra Ksiezyk 2020-8-25

回答： Rik 2020-8-25

I am running some simulation in a for loop where as outputs i am getting: Table_heating (matrix 12x6) and Table_dhw (matrix 12x6)

is there any possibility to save both tables in excel with all the simulations and not overwriting them ??

(to have it next to each other with 2 or 3 columns of space between next simulation ??)

Answer 1

Rik 2020-8-25

The easiest way is to read the excel file, append the new results and write the newly expanded cell array.

Alternatively you can use writecell(___,'WriteMode','append');.