How to save UITable into Excel for AppDesigner MATLAB?
조회 수: 51 (최근 30일)
이전 댓글 표시
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
채택된 답변
Adam Danz
2020년 7월 13일
편집: Adam Danz
2020년 7월 14일
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
Adam Danz
2020년 7월 14일
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)
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!