How to display results in a table and same time save results do excel file

1 次查看（过去 30 天）
Learning
Learning 2023-5-15
评论： Walter Roberson 2023-5-18
Hi, I have a code to predicting new data on an already trained model. How do I declare a property in app designer for the path where I import data from and also how do I display the prediction from the model in a table and at the same time save that result to an excel file when I click a button? Any code or example documentation would be appreciated. Thank you.

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2023-5-15
how do I display the prediction from the model in a table and at the same time save that result to an excel file when I click a button
Start by creating a table object -- though using array2table or related functions can also be valuable.
When you have the table of data to display, set a uitable object's Data property to be the table to display.
And use writetable to write to excel file.
  2 个评论
Learning
Learning 2023-5-17
Thank you for your help. Also, I have a code generated from a trained ANN model using the ANN fitting tool in Matlab. I can pass new data through the code and get an output. I have a button called “Predict”. When I click this button I want the output of the code to be displayed in the table. Do I implement the code at the callback for the “Predict” button? Also do I set the output of the code as a property so I can use it in the callback for “Predict”?
Walter Roberson
Walter Roberson 2023-5-18
Yes, the Predict button will likely call predict() or classify(), and after the code gets the results from that, put it into a Table and set the uitable's Data property to the table.
You can store the output of predict() or classify() as a property if you need it for other purposes beyond just displaying.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Develop Apps Using App Designer 的更多信息

标签

产品


版本

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by