How to avoid overwrite in excel in apps designer

Hi

I read many articles about how to avoid overwrite (WriteMode, Append, etc.) when exporting data from Matlab to excel, but none of them helped me to fix my problem.

I want to export tab data (table format) to Excel by selecting the path and also adding new data in next row. When I close the app and restart export to Excel, everything overwites in the previous excel file instead of adding to the end of last row. How I can fix the code?

My code is:

%keep data in the UITable3%

tab = app.UITable3.Data;

% get directory

selectPath = uigetdir('C:\','Please select Path for saving excel file');

%create xlsx file (Data.xlsx)%

filename = ('Data.xlsx');

writecell(tab,fullfile(selectPath,filename));

Answer 1

[Kevin Holly]

You can change the write mode as such:

writecell(tab,fullfile(selectPath,filename),'WriteMode','append');

[Mo]

Thanks, I used this format but I get error messag:

Invalid parameter name: WriteMode.

I used "WriteMode" and 'WriteMode' but the same error.

[Kevin Holly]

"WriteMode" became available starting in R2020a. Are you able to get access to a new version of MATLAB?

Alternatively, you could use xlsappend found on the File Exchange:

https://www.mathworks.com/matlabcentral/fileexchange/28600-xlsappend

[Mo]

It works in R2022b now. Many thanks