MATLAB Answers

How to save UITable into Excel for AppDesigner MATLAB?

103 views (last 30 days)
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.

Accepted Answer

Adam Danz
Adam Danz on 13 Jul 2020
Edited: Adam Danz on 14 Jul 2020
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
Adam Danz
Adam Danz on 14 Jul 2020
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)

Community Treasure Hunt

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

Start Hunting!