How to avoid overwrite in excel in apps designer

1 次查看（过去 30 天）
Mo
Mo 2023-1-5
评论： Mo 2023-1-5
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));

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

采纳的回答

Kevin Holly
Kevin Holly 2023-1-5
You can change the write mode as such:
writecell(tab,fullfile(selectPath,filename),'WriteMode','append');
  3 个评论
显示 1更早的评论
Kevin Holly
Kevin Holly 2023-1-5
编辑：Kevin Holly 2023-1-5
"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

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by