MATLAB Answers

How to save UITable into Excel for AppDesigner MATLAB?

64 views (last 30 days)
Arif Adam Bin Mohd Nor
Arif Adam Bin Mohd Nor on 13 Jul 2020 at 13:51
Edited: Adam Danz on 14 Jul 2020 at 14:29
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.

  0 Comments

Sign in to comment.

Accepted Answer

Adam Danz
Adam Danz on 13 Jul 2020 at 17:55
Edited: Adam Danz on 14 Jul 2020 at 14:29
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

  6 Comments

Show 3 older comments
Adam Danz
Adam Danz on 14 Jul 2020 at 11:58
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
Arif Adam Bin Mohd Nor on 14 Jul 2020 at 13:08
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
Adam Danz on 14 Jul 2020 at 14:28
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)

Sign in to comment.

More Answers (0)