How can i export data from an 'edit text box' in app designer to an excel file?
12 ビュー (過去 30 日間)
古いコメントを表示
Hi,
So i want to export the variables below (in the edit text boxes) to an excel spreadsheet. But i am not sure how to to it.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/291834/image.png)
I want to create a callback function fot the 'save data' button, so that when it is pressed, the data is saved to excel spreadsheet.
Can anyone give me some advice on how to do this?
Thanks in advance, Grace
0 件のコメント
回答 (1 件)
Peng Li
2020 年 5 月 10 日
I assume that you have properties linked to each of these values.
In the callback, you can create a structure or a table involving all what you want, and write them to excel once.
For example,
tbl = table(yourApp.TimeTaken, yourApp.MaxHeight, yourApp.Horizontal, ...
'VariableNames', {'TimeTaken', 'MaxHeight', 'Horizontal'});
writetable(tbl, yourOutputDir);
In above example, I assue the handle of your app is your App, and the property names corresponding to the first three edit boxes are TimeTaken, MaxHeight, Horizontal.
If you didn't link them to a seperate property, you can manipulate through accessing the Value property of the corresponding text edit, e.g.,
tbl = table(yourApp.TimeTakenEdit.Value, ...)
5 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!