How to save UITable into Excel for AppDesigner MATLAB?
44 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Arif Adam Bin Mohd Nor
el 13 de Jul. de 2020
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 comentarios
Respuesta aceptada
Adam Danz
el 13 de Jul. de 2020
Editada: Adam Danz
el 14 de Jul. de 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 comentarios
Adam Danz
el 14 de Jul. de 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)
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!