How to save UITable into Excel for AppDesigner MATLAB?

Hi. I created a UITable with 4 columns (A,B,C,D). All data are numericals. When I press the button 'RUN' the tables were tabulated automatically. How do I automatically save the table in an Excel file when I press 'RUN'? How should I code in the 'code view'? I am using R2016B version. Thank you.

Answer 1

[Adam Danz]

The data are stored in the Data property of a UITable within a mxn cell array. For Matlab r2019a or later, use writecell() to write the data to an excel file. Prior to that, use xlswrite().

It will look something like this.

data = app.UITable.Data; 
filename = 'testdata.xlsx';
writecell(data,filename)

Here's a full demo

https://www.mathworks.com/help/matlab/import_export/exporting-to-excel-spreadsheets.html

[Arif Adam Bin Mohd Nor]

Hi. Thank you for your reply. When I tried to run the code you've given, the message 'Undefined function 'writecell' for input arguments of type 'double'.' appeared. Would you know why this happened? Thank you.

[Adam Danz]

Try using writematrix or writetable.

[Arif Adam Bin Mohd Nor]

The same message appeared for both cases. Is there any other way?

[Adam Danz]

You didn't fill in your Matlab release information in the question. Are you using r2020a or a different release?

[Arif Adam Bin Mohd Nor]

I did mention the version I am using in my question in the last sentence before 'Thank you'. which is the R2016B release. Thank you.

[Adam Danz]

Oh, I see it now in your question. Thanks for including it. If you look to the right, there's a "Products" and "Release" field where you can fill in your release while you're writing your question. That's where I usually look.

The functions I recommended were released in r2019a which is why you're getting those errors.

Looks like you'll need to use xlswrite(filename,A)