Append array to row of the excel sheet without overwriting.

I am trying to apped one of the array (lets say xx) which stores certain data entries(All of same type) to excel row.

I will be running the same code multiple times and data that is stored in array (xx) is renewed every iterations and i would like to store data to excel sheet before i give command for running new iteration.

xlswrite(['File_Address\Filename.xlsx'], xx,';append' )

the above command overwrites the exisiting data instead of writing data below it. (Array size remain constant.)

[Simon Chan]

If your MATLAB version is R2019a or later, it is better to use function writematrix, writecell or writetable with append option.

[Yashvardhan Bhati]

Thanks this works. @Simon Chan

writematrix( xx,['FileAddress\Filename.xlsx'],'WriteMode','append')